Add Sum Field To Query

Adding Sum fields to your query allows you to add the values in numeric fields together. For example, you can list the total sum of values for a specific field. When a Sum field is added, the query results includes exactly one record with the indicated sum 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 box, press Other.

   The Other field is added. The Additional Query Functions form is displayed.

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