tlsparker Posted December 7, 2001 Share Posted December 7, 2001 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. Link to comment Share on other sites More sharing options...
SteveB Posted December 8, 2001 Share Posted December 8, 2001 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8174 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now