help with counting

[Guest]

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

 

[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.