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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using one calculation in another 1
How to count number of entries for a non exact keyword 9
Count text values in a Access Field 0
Count Matching records 2
Importing Date fields from Excel 2
Case of the curious query ; count the codes 2
How to count consecutive records base on 2 groupings 0
how can i write ansi sql quires equalent to ms access and sql ser. 1

Back
Top