Database Reference
In-Depth Information
If you are using the Simple Query wizard to build a query with fields that contain numeric data,
you can have the wizard add an aggregate function to the query.
When creating a query manually, or modifying an existing query, you can click the Totals
button in the Show/Hide group on the Design tool tab to add a Total row to the grid. You
can then select the aggregate function you want from a list. The list also allows you to
group fields, select the first or last record that meets the specified criteria, enter an expres-
sion, or make additional criteria refinements.
7
TIP
You don't have to create a query to summarize all the data in a table. You can display
the table in Datasheet view and then on the Home tab, in the Records group, click the
Totals button to add a Total row at the bottom of the table. (Clicking the Totals button
again removes the row from the table.) In the Total row of each field, you can select the
type of summary data you want to appear from a list. The types available for each field
depend on its data type. For example, you can count all fields, but you can only calculate
the sum or average of fields containing numeric data.