Expression 1

Enter the first expression of the HAVING clause manually, or use the list boxes, drop-down lists, and keypad to build an expression.

If you select the EXISTS or NOT EXISTS operator, this field disappears.

Operator

Lists all valid operators for the HAVING clause. You can select only one operator.

If you select BETWEEN or NOT BETWEEN, the AND entry field appears.

If you select EXISTS or NOT EXISTS, the Expression 1 field disappears, and the Expression 2 field is renamed Expression.

Expression 2

Enter the second expression of the HAVING clause manually, or use the list boxes, drop-down lists, and keypad to build an expression.

If you select the EXISTS or NOT EXISTS operator, this field is renamed Expression.

AND

This entry field appears when you select the BETWEEN or NOT BETWEEN operator. Enter the third expression of the HAVING clause manually, or use the list boxes, drop-down lists, and keypad to build an expression.

Conjunction

Enabled after you have applied a HAVING clause. Select AND or OR to connect your search conditions as you build them.

Table

Lists the tables selected for the current statement. When you select a table, all the columns in that table appear in the Columns list box

Column

Lists all the columns in the selected table. You can select a column from this list to use in any expression.

Function

Lists the available built-in functions.

Keypad

Use to select arithmetic and logical operators when you are creating an expression.

Subquery

Invokes the Subquery Editor window and lets you create a subquery (nested SELECT) statement. When you select Done in the Subquery Editor window, the text of the subquery will appear in the HAVING Clause dialog box, in the Expression field that last had the focus.

Apply

Adds the HAVING clause to the current statement and displays it in the SQL Editor window.

Close

Closes the dialog box. If you have not applied the clause, it does not appear in the SQL Editor window.

Help

Displays help for the dialog box.