How to Create a Totals Row in Access
Create a Totals row in two clicks. A Totals row allows you to see, at a quick glance, what the totals are for a given field within a table.
Totals rows apply an aggregate function to all values in the field and display the result in its own dedicated row.
You can use a Totals row to calculate the sum of all values, an average of the values, a count of the records in the table, minimum value, maximum value, standard deviation (how widely values are dispersed from an average value (a mean)), and variance (statistical variance of all values in the column).
Save the Changes
If you want the Totals row to be permanent, be sure to save the changes you just made to the table.
Here, we will close the table and re-open it again. That way we can test it to make sure the changes will still be there when we re-open the table.
You don't actually need to close the table. I just did that to demonsrate how the table will look when you open it again.
You can save the table using the usual methods if you prefer (eg, by right-clicking on the table's tab and selecting Save).
There's nothing to stop you from creating a temporary Totals row. You can do this simply by not saving the changes. You could do this if you ever wanted to do a quick total without committing it to the database.