Having Dialog Box

See Also

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.

Dialog Box Options

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.