Double-click or drag a schema or statement to add it to the Table Diagram area.
On the Statement Options tab, select the Group Records Together check box. The Group Criteria tab appears in the Query Specification area.
If you are working with a statement, right-click in the Group Criteria tab and select Add Group Criterion. The Specify Criterion Wizard appears.
If you are working with a schema, the statement in the SQL Statement tab changes to SELECT COUNT (*) FROM "Tablename" (where Tablename is the name of the table you are working with) when you select the Group Records Together check box. To add a group criterion to a schema, do the following:
Click the Table Diagram tab to display the table you want to create a group criterion for.
In the Query Specification tab, select the columns you want to group by. Each selected column is added to the SQL Statement area.
Right-click in the Group Criteria tab and select Add Group Criterion. The Specify Criterion Wizard appears.
To create the group criterion, follow steps 3 to 5 in To create a criterion. How?