Defining Expression Criteria
Use the Criteria column in the Columns Pane to define query criteria for the listed expression. Enter the criterion while omitting the expression itself.
For example, if you want to select the expressions that are greater than or equal to 10, but less than or equal to 20, the expression with the criterion looks like this:
WHERE (field
>= 10) AND (field <= 20)
To select those expressions, enter the following in the Criteria column:
>= 10 AND
<= 20
If you have multiple criteria for a single expression, enter each additional criterion in the Or... columns. These criteria will be concatenated in the query using the OR operator.