Home > Sample chapters > Microsoft Office > Access

Selecting Data Using Queries in Microsoft Access 2013

Creating a summary calculation

A summary query can be used to perform different summary calculations on your data. It supports the calculation of Sum, Max, Min, Avg, and other calculations.

After you have changed your query into a summary query, any new columns added to the query are displayed as the default Group By values and group the data by that column. You can also change the Total row to Where, when you want to filter the data, or to a calculation such as Avg.

Add a summary

  1. Click the Totals button.

  2. Use Group By to group your results; you can add multiple fields.

  3. Choose summary calculations.

  4. Filter the records to summarize by using the Where selection.