Select this option to build a HAVING clause as part of a previously defined GROUP BY clause.  A HAVING clause is like a WHERE clause for groups in that it limits the groups retrieved in a GROUP BY clause, just as a WHERE clause limits the rows retrieved in a SELECT statement.

Pressing OK in the Having dialog box adds the HAVING clause to the current SELECT Statement.  The SQL Statement window displays the HAVING clause as part of the current SQL statement.

Having Dialog Box

Column:

Select a column to be used in the search condition for the HAVING clause.

Operator:

Choose the comparison operator to be used in the search condition of the HAVING clause.

Comparison:

Select the Literal or Variable radio button to indicate the type for the second part of the search condition for the HAVING clause.

If you choose to use a Literal value, you may type it, or use the List push button to bring up the Copy Value dialog box.

The Copy Value dialog box displays the distinct values for the column you have selected and allows you to copy one to the HAVING clause or to the clipboard.

If you choose to use a variable, a name for the variable is generated automatically, or you may type a name into the entry field.

Operator:

Choose a conjunction operator--AND, OR, or NOT--to join two search conditions in the HAVING clause.

Clause Options:

The HAVING clause is displayed here.

Use the Add button to add the search condition you have built to the HAVING clause.  The Add button may be used to build multiple search conditions into the HAVING clause.

Use the Remove button to remove portions of the HAVING clause, or the Clear All button to erase the entire HAVING clause.