Adrienne has attended:
Access Introduction course
Access - calculating records
Hi
I have a table with 1000 records of approx 50 cities. Is there a way to make a query of 50 records (1 per city) in total with an extra column reading the quantity of records (i.e. approx 20 per record)?
I hope this makes sense.
Regards
Adrienne
RE: 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
