Count the number of occurennces of Zip Code

[Glenn Dulmage]

Access 2000

I have a query on a table which has 5 Zip Codes. I want to design a report which Counts the number of occurrences of each Zip Code. I have followed the Grouping thread and somehow nothing seems to apply.

Can anyone help?

--
Glenn T. Dulmage
207 Valley Road
Chestertown MD 21620
410-778-5166
(e-mail address removed)

 

[PC Datasheet]

Create a query that includes the zipcode field twice. Click on the sigma
(looks like E) button on the toolbar at the top of the screen. Under ONE of
the zipcodes, change Group By to Count. Run the query and you will get
something like:
Zip1 5
Zip2 3
Zip 3 7
Zip4 1
Zip5 9

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


Access 2000

I have a query on a table which has 5 Zip Codes. I want to design a report
which Counts the number of occurrences of each Zip Code. I have followed
the Grouping thread and somehow nothing seems to apply.

Can anyone help?

--
Glenn T. Dulmage
207 Valley Road
Chestertown MD 21620
410-778-5166
(e-mail address removed)

 

[Glenn Dulmage]

Wow!! That is so slick. I read and read in the Access 2000 Bible and could
not find anything. Your solution is so simple and elegant.

Thank you so much.

Glenn