You can add a Total row to a table in Datasheet View, which calculates the sum of the values for its field.
- In Datasheet View, click the Totals button on the Home tab.
The Totals row now appears at the bottom of the datasheet.
- Click the Total row’s cell for the column that you want to display a total for.
- Click the list arrow.
The menu that appears lists all the functions for the column you want to display the total for.
- Select the function that you want to perform on the field.
Access displays a value in the current cell, which is based on the function that you selected.