To build a query with grouping, mark expressions for grouping with the Grouping check box.
A query with grouping may have only grouping or aggregate expressions in the SELECT list. Thus the query builder allows you to set the Output check box for grouping and aggregate expressions. If you try to set this check box for a column without the grouping or aggregate function set, a Grouping check box will be set automatically to maintain the validity of resulting SQL query.
When the Columns pane contains columns marked with the Grouping check box, a new column called Criteria for appears in the grid. This column applies criteria to expression groups or to their values.
For example, you have a column "Quantity" with Aggregate function "Avg" in your query
and you type > 10
in the Criteria column. Having the "for groups"
value set in the Criteria for column, the resulting query will contain only groups
with an average quantity greater than 10, and your query will have the
"Avg(Quantity) > 10" condition in a HAVING clause. Having the "for values" value set
in the Criteria for column, the result query will calculate the Average aggregate
function only for records with Quantity value greater than 10, and your query will
have the "Quantity > 10" condition in WHERE clause.