Query Wizard - Detail or Summary

Specifies whether to display all records of the query, or only the results of aggregate functions.

This page is only displayed when there are numerical fields in the query that allow the use of aggregate functions.

Detailed query

Select to show all records of the query.

Summary query

Select to show only results of aggregate functions.

Select the aggregate function and the field name of the numeric field in the list box. You can enter as many aggregate functions as you want, one in each row of controls.

Aggregate function

Select the aggregate function.

Field name

Select the numeric field name.

+

Appends a new row of controls.

−

Removes the last row of controls.

Query Wizard - Grouping