Add Average Field to Query

Adding Average fields to your query allows you to average the values in numeric fields together. When an Average field is added, the query results includes exactly one record with the indicated average value (multiple records are returned only if the Group By section is completed).

1. From the Tools menu, select the Queries... option.

   The Queries form is displayed.
   

2. Select the module and record area, and either create a new query, or modify an existing query.

   Information on creating or modifying a query is available in Create New Query and Modify Query.

3. In the Query Designer form, Fields section, highlight the field name in the left-hand box then press .

   The Average field is added.

4. Complete the Group By section before saving the query.