Jump to content
Sign in to follow this  
tlsparker

Finding & Counting records

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.