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 of the Query Designer.
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 Expression Builder 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.