Мастер запросов - Детальный или итоговый

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.

Детальный запрос

Select to show all records of the 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.

Агрегатная функция

Select the aggregate function.

Имя поля

Select the numeric field name.

+

Appends a new row of controls.

−

Removes the last row of controls.

Мастер запросов - Группировка