Finding & Counting records

[tlsparker]

Create a summary field , ZipSum, defined as count of ZipCode. Create a subsummary part (sorted by ZipCode). Place ZipCode and ZipSum in the sumsummary part. Go to preview mode, and you should have your list as desired.

[SteveB]

I'm trying to find all the zip codes of customer records in a given state and count the number of records in that zip code. I only want to display the zip code once and its associated count like the following:

89100 34

89122 10

I tried using the Count of Summary calculation on the field 'Zipcode' in a trailing sub-summary, but I don't get anything. I know I can loop thru the records in a script, but is there a way to do this without a "hammer & chisel"? Thanks. Steve.