Microsoft Office Tutorials and References
In Depth Information
Adding a Total Row to the Datasheet
a sum or average, or find the minimum or maximum value. All these options
are aggregate functions, which you can use in queries and in a total row on a
Follow these steps to create a total row:
1. Display the datasheet.
2. Click the Totals button in the Records group on the Home tab of the
Access creates a row titled Total at the bottom of the datasheet.
3. Click one of the blank cells in the total row to display an arrow; then
click the arrow to display a drop-down menu of aggregation options.
4. From the drop-down menu, choose the kind of total you want to display.
The choices are None, Sum, Average, Count, Maximum, Minimum,
Standard Deviation, and Variance. For Text and Rich Text fields, you can
choose Count to count the number of entries in the field. For Date fields,
your choices are limited to Average, Count, Maximum, and Minimum.
Access displays the aggregate, as shown in Figure 1-19. To change the
kind of aggregation, simply select the cell and choose another option
from the drop-down menu.
tab of the
the type of
you want for
To clear the total row, simply click the Totals button again. If you change
your mind and want your aggregates back, Access remembers the type of
aggregation you chose for each field. You may also want to add a total row
to queries displayed in Datasheet view (see Chapter 2 of this minibook).
The totals adjust when a filter is applied to the datasheet, as discussed in
Chapter 2 of this minibook. Total rows don’t appear in subdatasheets.