count zipcodes

[FirstCM]

I have a database of 15000 adresses and I need to find out how many are going
to each zipcode. The zipcodes are spread across the country and to do it
manually could take days. Is there an easy way to get those counts to
display as:

Zipcode count
61109 10
53527 350
00793 25

 

[Bob I]

Query with "Group" and "Sum".

 

[George Nicholson]

Query with "Group" and "Sum".

um, I think you meant: create a query with the ZipCode field included twice.
Once set to GroupBy, once set to *Count*

 

[Bob I]

Thank you for the correction! Count NOT Sum.

um, I think you meant: create a query with the ZipCode field included twice.
Once set to GroupBy, once set to *Count*