Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training course - Access - calculating records
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft access training course - Access - calculating records
Resolved · Low Priority · Version Standard
Reply Fri 23 Nov 2007, 11:35Delegate Adrienne said...
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
For upcoming training course dates see: Pricing & availability
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
Reply Fri 23 Nov 2007, 15:19Delegate Adrienne said...
RE: Access - calculating records
Carlos this is exactly what I was hoping for!
Regards
Adrienne
|