Share via


Having Dialog Box

Specifies conditions for selecting which groups of records to include in query output. This dialog box appears when you choose Having in the Group By Tab, Query and View Designers.

  • Field Name
    Specifies a function, field name, or other expression. Select from a list of functions, a list of field names for each table, or use the expression command to display the ExpressionBuilder dialog box. If you choose a function, a submenu displays a list of field names available to use with that function.
  • Not
    Reverses the comparison criterion.
  • Comparison Criteria
    Specifies the comparison criterion. Options are Equal (=), Like, Exactly Like (==), Greater Than(>), Less Than(<), Greater Than or Equal To (>=), Less Than or Equal To (<=), Is NULL, Between, and In.
  • Example
    Specifies the value you want the field to be compared to.
  • Case
    Specifies whether to match case (upper or lower) of the example in your condition.
  • Logical
    Adds an AND or OR condition in the list of conditions.
  • Insert
    Inserts a blank row above the selected condition.
  • Remove
    Removes the selected row from the Field Name list.

See Also

Group By Tab, Query and View Designers | Query and View Designers | SELECT - SQL Command | CREATE QUERY Command | Creating a Query