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