Sums in a table

Dear Irmina

Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.

In order to perform Sum, Average, Count, Min, Max, etc... you have to create a summary query. This is particularly useful if you are trying to analyse how much worth of goods a specific client has bought or how well is a product doing, etc...


Please follow these steps:

Click on the Query in the objects Bar

Click New

Choose the Design and Press OK

From the Show Table Window choose the table the fields need to come from

Click the Add button.

Close the show table window

From the small Table window double-click on the fields that you need in your query. Preferably double-click only the fields where the data is duplicating and the one which you want to perform the calculation on. E.g. If the table was called Transactions then Customer names and Qty ordered.

Once the field have been downloaded click the Totals button on the toolbar (this is the same Autosum button in Excel)

On the Grid box you'll see Totals will appear and also under each field you will see Group By

Click on the Group By for the filed that you wish to perform the calculation. From the drop down arrow choose Sum, Average, Min or Max

When you run the Query you'll notice that the one field will be grouped and the other one will be providing you the summary.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007