Use the Total Row

By default, the Total Row uses Group By for each Field. The other options include:

Sum

Avg

Min

Max

Count

SDev

Var

First

Last

Expression

Where

 

2. Try it: Edit the Total

Go to the Movie Column.

Change the Total: Count

 

Go to the Price Column.

Change the Total: Sum.

 

Keep going, please.

Query Tools ->Design->Show/Hide->Totals

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.3. Manipulate fields: Use the Totals Row