List and count zip codes
in [Reports]
|
From: John Barnes on 8 Jul 2008 21:47 I have a ZipCode field and would like to list, and count, every zip code that user has entered. How would I do that? I know how to create a field that counts the number of times user has entered a specific zip code, but how can I display a list of every code entered and the number of times it has been entered?
From: John Spencer on 8 Jul 2008 22:33 SELECT ZipCode, Count(ZipCode) as CountEntries FROM YourTable GROUP BY ZipCode In design view of a query. -- Add your table -- Add the ZipCode field TWICE -- SELECT View: Totals from the menu -- Change Group By to Count under ONE of the ZipCode fields. -- Run the query '==================================================== John Spencer Access MVP 2002-2005, 2007-2008 The Hilltop Institute University of Maryland Baltimore County '==================================================== John Barnes wrote: > I have a ZipCode field and would like to list, and count, every zip code that > user has entered. How would I do that? I know how to create a field that > counts the number of times user has entered a specific zip code, but how can > I display a list of every code entered and the number of times it has been > entered?
|
Pages: 1 Prev: crosstab non-fixed column subreport in details section Next: Passing data to a Report |