How To Add A Total Row In Access

How to Create a Totals Row in Admission

Create a Totals row in two clicks. A Totals row allows you lot to see, at a quick glance, what the totals are for a given field within a table.

Totals rows apply an aggregate role to all values in the field and display the result in its own dedicated row.

You lot can utilise 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).

Select the Totals Option

Open the table in Datasheet View and click Totals in the Ribbon (from the Abode tab).

A new row will exist appended to the table with the word Total in the outset column.

In this screenshot, I scrolled to the bottom of the table. Still, this is not necessary. Admission displays the Totals row equally a fixed row, regardless of where the scroll position is.
Select which Field and Function

In the new Full row, click in the field you lot desire the total to exist applied to.

Select the desired function from the drop-downward listing.

In this example, we apply a Sum function to the Population field. This volition add together upwardly the population of all countries, and the total volition appear in our new totals row.

The available functions depend on the data blazon. For instance, if you lot try to add a Totals row to a text field, yous'll merely exist able to select Count (for counting up the rows).
Your Totals Row

Access will automatically generate the full when yous select the desired option.

Salve the Changes

If y'all want the Totals row to be permanent, be sure to save the changes yous just fabricated to the table.

Here, we will close the table and re-open up information technology again. That way we tin can test it to brand certain the changes volition nevertheless be there when we re-open the table.

Shut the Table

Close the tabular array (using the little 10 icon).

Click Aye at the prompt.
Open the Table and See the Totals

Open the table again, and you will see the Totals row is still there.

Observe that the Totals row is fixed to the bottom of the table. So you don't have to curl downward to see the Totals row. Y'all tin can even so see it even as you gyre up and down.

You don't really need to close the table. I only did that to demonsrate how the tabular array will expect when you open it again.

Y'all can save the table using the usual methods if you prefer (eg, past right-clicking on the table's tab and selecting Salve).

There'south cypher to stop you from creating a temporary Totals row. Y'all tin do this just by not saving the changes. Yous could do this if you always wanted to do a quick total without committing it to the database.