microsoft access training course - Access - calculating records

Hi Adrienne

Yes there is.

I assumen the field holding the ciy names is called "City"

Create a new query in design view, with the "City" fiels as the 1st item on the query.

In the next query field place another of the table's fields (NB you could use the "City" field again)

On the toolbar click the Totals button. (The "E" AutoSum symbol)
An new line Total appears in the design view

Leave the 1st item's value as Group By but change the other's value to Count

When the query is run you will have a table view, with a list of all the individual cities with the number of records for each appearing in the 2nd column of the table.

Hope this helps.

Carlos