Query Property Sheet Group By Tab

This tab lists the columns in the GROUP BY clause, which control how the data retrieved by the query will be grouped.

You can add or delete columns as appropriate, and reorder the columns in the list using the arrows at the bottom of the tab. Any changes you make will propagate to the query's SQL tab and to the SQL Query tab of the parent view.

Click in the first empty row in the list.
Select a column from the list. To enter a more complex expression via the SQL Editor, click the ellipsis button to the right of the list.