Counting records of same value in access 2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 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.
 
Back
Top