If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Count the number of occurennces of Zip Code
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 |
#2
|
|||
|
|||
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 www.pcdatasheet.com "Glenn Dulmage" wrote in message ... 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 |
#3
|
|||
|
|||
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 "PC Datasheet" wrote in message nk.net... 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 www.pcdatasheet.com "Glenn Dulmage" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I can receive email but cannot send it. | pegasus | General Discussion | 175 | April 27th, 2010 05:49 PM |
Combo Box (1st) Populating Text Box (2nd) Field | AccessRookie | Using Forms | 1 | April 6th, 2005 11:37 PM |
Combo Box & Text Box | AccessRookie | Using Forms | 3 | April 6th, 2005 11:33 PM |
Outlook XP email goes to sent folder -receipient doesn't receive,. | Jobde | General Discussion | 3 | February 9th, 2005 04:29 PM |
incorrect sums in report using 2 tables | jkendrick75 | Setting Up & Running Reports | 22 | December 13th, 2004 02:19 PM |