Quick summary
This tutorial shows how to create aggregate queries in Microsoft Access using the Query Design view. You will learn how to add tables, select fields, enable the Totals row, and apply aggregate functions to summarize data.
Steps
- Go to the Create tab in the MS Access ribbon.
- Select the Query Design button to open the query builder.
- Add the tables or queries you want to use, then click Add Selected Tables.
- Drag the desired field into the query grid.
- Click the Totals button in the Query Design toolbar to enable the Total row.
- For each column in the query, select an aggregate function in the Total row (e.g. Sum, Count, Avg).
- Click the Run button to execute the query and view the aggregated results.
