Interactive Tutorial
How to Add Total Rows in Access
4.9 out of 5 on G2
Practice live in your browser. No software required.
5 Hour Course Certificate
Free quick tips and shortcuts to use and share.
Step-by-step instructions with screenshots.
You can add a Total row to a table in Datasheet View, which calculates the sum of the values for its field.
The Totals row now appears at the bottom of the datasheet.
The menu that appears lists all the functions for the column you want to display the total for.
Access displays a value in the current cell, which is based on the function that you selected.