When you create a criterion, you need comparisons to designate the relative values on either side of the criterion. Select these from the list box next to the Comparison option.
is equal to |
is not equal to |
is greater than or equal to |
is greater than |
is less than or equal to |
is less than |
is between (two values) |
is not between (two values) |
is in (a list of values) |
is not in (a list of values) |
matches mask (LIKE) |
no match for mask |
is null |
is not null |