- Aggregate data
To aggregate data in Access, start by selecting the “Totals” button in the tool bar to create a “Total” row at the bottom of the datasheet table view.
Then move the cursor to the field you wish to aggregate and right-click to expose the options.
From this approach, Access offers a Sum, Average, Count, Maximum, Minimum, Standard Deviation, and Variance aggregation option.
Contributors and Attributions
- Aggregating Data. Authored by: Robert Danielson. Provided by: Lumen Learning. License: CC BY: Attribution