Queries - Calculations on records in a query

The Totals button can be used to many calculations.  It can Sum (which means add), Avg (Average), Min (Minimum), etc. 

Note the criteria in the query and its results.  The Totals button has not been selected.  The records are sorted in the order in which they were entered, that is why it is not in ascending alphabetical order.

Criteria	After the query has been Run

The Totals button was clicked.  Below the Types have been grouped together, in ascending alphabetical order, with their costs.

Criteria	After the query has been Run

The query looks similar to that above, but there are differences.  Look at the result of the query.  The costs of all the Types of applications were summed or added together.

Criteria	After the query has been Run

In the query, in the Cost field, the Total was counted.    One can see the number of Types of applications.

Criteria	After the query has been Run

This work may be freely copied for non-commercial use only. Copyright © Pam Miller