How to Add Total Rows in Access
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.
Free to distribute with our compliments; we hope you will consider our paid training.