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