Criteria condition operators

This criterion

Qualifies a record if the first argument

=

Is equal to the second argument

<>

Is not equal to the second argument

>

Is greater than the second argument

>=

Is greater than or equal to the second argument

<

Is less than the second argument

<=

Is less than or equal to the second argument

This criterion

Qualifies a record if its value

Is Null

Is null

Between

Is greater than or equal to the first value (lower limit) and less than or equal to the second value (upper limit)

In List

Is included within the list defined in the Edit box. When entering the list, press <Enter> between each value.

Begin with

Begins with the character(s) entered in the Edit box

Ending with

Ends with the character(s) entered in the Edit box

Including

Contains the character(s) entered in the Edit box

Like

Like the value entered as argument in the Edit box using wildcard such as ? and *

Is Not Null

Is not null

Not Between

Is not included in the range of values defined for the lower limit and the upper limit

Not In List

Is not included within the list defined in the Edit box. When entering the list, press <Enter> between each value.

Not Begin with

Doesn’t begin with the character(s) entered in the Edit box

Not Ending with

Doesn’t end with the character(s) entered in the Edit box

Not Including

Doesn’t contain the character(s) entered in the Edit box

Not Like

Isn’t like the value entered as argument in the Edit box using wildcard such as ? and *