Calculate Totals in a Query

You can use this Query to calculate the Total for each Receipt. The first step in calculating the Totals is to Group the data. The Records will be Grouped By ReceiptID first so that each Receipt can be totaled separately.


1. Try it: Show the Total Row

The rptReceiptSQ is open in Design View.

Go to Query Tools ->Design->Show/Hide

Click on Totals.


What Do You See? There should be a new Total Row in the QBE Grid. The Totals Row has Group By as the value for each Field.


OK, the Total Row is shown and ready to go. Keep going...

Query Tools ->Design->Show/Hide->Totals

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.3. Manipulate fields: Calculate Totals