Share via


Group By Tab, Query and View Designers

Groups rows of query or view results. This tab appears in the Query and View Designers. For more information, see the GROUP BY clause in the SELECT - SQL Command.

  • Available Fields
    Lists all the available fields in the tables of a query or view and other expressions.
  • Grouped Fields
    Lists the fields, aggregate functions, and other expressions for determining the grouping of the query results. Fields are grouped in the order they appear in the list. You can change the field order and the grouping hierarchy by dragging the double-headed arrow to the left of each field.
  • Add
    Adds the selected item in the Available Fields box to the Group ByFields box.
  • Remove
    Removes the selected item from the Group By Fields box.
  • Having
    Displays the Having Dialog Box for setting selection criteria on groups rather than on individual records.

See Also

Fields Tab, Query and View Designers | Filter Tab, Query and View Designers | Having Dialog Box | Order By Tab, Query and View Designers | Query and View Designers | SELECT - SQL Command | Update Criteria Tab, View Designer