Using Aggregate Functions to Calculate Totals in Queries

To use aggregate functions in queries:

1. Begin with a query that includes the records for which you want to calculate a total.
2. Open the query in Design View.
3. Click the Totals button to add the totals row to the query grid.
4. Click in the Total: row for the field that contains the values you want to total.
5. Click the arrow and select the aggregate function you want.
6. Click the Run button.

To add an aggregate function to a query, begin with a query open in Design view. Click the Totals button to add the totals row to the query grid. Click the total cell for the field that includes the values you want to total. Click the arrow and select the aggregate function you want. Click the Run button to see the results of your query. Each row shows the calculated total for that group of records.