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.

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.