Comparison

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

See Also

Building Criteria