HAVING tab

Criteria Use the Criteria pane to enter your HAVING conditions. You can type directly into this pane, or use the Expression Editor. To edit existing expressions, highlight the expression before you open the Expression Editor. Otherwise, what you create in the Expression Editor is appended to previously existing expressions.
Build HAVING expression Click the Build HAVING expression button, located in the bottom right of the Criteria pane, to open the Expression Editor and build your HAVING condition.
Results Click Results at the bottom of the window to see the results of your query, or an error message if the query contains errors.
SQL Click SQL at the bottom of the window to see the SQL statements for your query.

HAVING conditions can only be used if either the statement has a GROUP BY clause or the selected columns in the Columns tab include only aggregate functions. Any column names referenced in the HAVING clause must either be in the GROUP BY clause or be used as a parameter to an aggregate function in the HAVING clause.

For more information about the Query Editor, see Using the Query Editor.
For an introduction to HAVING, see Applying aggregate functions to grouped data.
For more information about HAVING, see The HAVING clause: selecting groups of data.

HAVING tab

Components

About HAVING conditions

See also