help with counting

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top