You can set a Having condition that defines conditions for displaying groups in a query.
Notes:
You must add a Group By clause for this option to be available.
To set a Having condition
Select a column from a table in the Diagram tab.
Select the Having Condition field below the column and click .
Complete the fields as necessary. Review the following for additional information:
Form Tab |
Description |
---|---|
Field |
Select an operator or predicate to use in this condition. |
Aggregate |
Select one of the following functions to calculate column values:
Note: If you add a Group By clause, you must specify an aggregate function for any remaining columns. |
Value 1 Type Value 2 Type |
Select whether the expression is a column or constant. After selecting this option, select the column name or enter a constant in the field. Note: The Value 2 Type field is only available if you selected the Between predicate. |
Formula Tab |
Description |
Functions |
Perform an incremental search or select a function, and then select a column on which to perform the function. |
Operators |
Select an operator or predicate to use in this condition. |
Columns and Calculated Fields |
Select a column to apply a function or operator against. |
Tip: To remove a Having condition, open the Having condition window and click Remove.
© ALL RIGHTS RESERVED. Términos de uso Privacidad Cookie Preference Center