help with counting

D

davek

how do I summarize the number of "types" of records I have in a database?
for example:
city
phila = 20 records
New york = 45 records,

etc.
please advise
 
L

Les

Create a new query, using whatever field
indicates "types". Select this field twice. Click the
totals button. You should now see "group by" in both
totals lines. Change the 2nd one to count. It should
give you what you want.
 
Top