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