Counting records of same value in access 2002

J

Juana

I have a large database of addresse. Need to know how many addresse are in
the same zip code. Can I do a quiry and how?

Thank you for your help
 
J

JudithJubilee

Hello there,

Yes you do need a query. A Total query.

Create a query with the Zip Code and 1 address field.
Click on the Total icon on the toolbar (looks like
AutoSum in Excel). This adds another row to your query.
Keep Zip Code on Group By and change the Address field to
Count.

This will give you a list of all the unique Zip Codes and
how many addresses are in each one.

I hope this helps

Judith
 
J

Juana

J J, YOU are a life saver ! Thanks a Million for your valuable help. You
saved my rear end. :)

Hope I can benefit from your expertise in the future.
 
Top