Conditions for Numeric, Alphanumeric and Time Fields

To define a condition applied to a numeric, text or time field:

1. Select either a numeric, text or time field.

   

2. Define the type of comparison (equal, greater etc.).
3. Determine what to compare the contents of the field with. Choose between Fixed, Variable, Field (compare with the contents of another field), see Variable Conditions and Comparing Field Contents. If you select Fixed, you can enable Use as parameter (requires user input) to allow users to enter the comparison value when executing the query, see Parameters and Predefined Queries.
4. Enter the comparison value in the Value field.
5. Enable the Use as Parameter option if you want the comparison value to be entered by the user upon starting the query, see Parameters and Predefined Queries.

   Wildcards (*, ?) may also be used for text fields.

6. Click on OK to return to the query overview.