How to Add a Total Row in Access

You can add a Total row to a table in Datasheet View, which calculates the sum of the values for its field.

1. In Datasheet View, click the Totals button on the Home tab.

   The Totals row now appears at the bottom of the datasheet.

2. Click the Total row’s cell for the column that you want to display a total for.
3. Click the list arrow.

   The menu that appears lists all the functions for the column you want to display the total for.

4. 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.