Quick summary
The Sum function in MS Access lets you calculate totals across a field by building a totals query in Query Design view. This step-by-step process uses the built-in Totals button and aggregate options to return summed values without writing SQL manually.
Steps
- Go to the Create tab in the MS Access ribbon.
- Select the Query Design button to open a new query in Design view.
- Click Add Selected Tables to add the table containing the field you want to sum.
- Drag the desired field into the query grid.
- Click the Totals button (Σ symbol) in the ribbon to enable the Total row.
- In the Total row for the field, select Sum from the dropdown menu.
- Click the Run button to execute the query and display the summed result.
