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. |
Begins with the character(s) entered in the Edit box | |
Ends with the character(s) entered in the Edit box | |
Contains the character(s) entered in the Edit box | |
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 |
Doesnt begin with the character(s) entered in the Edit box |
Not Ending with |
Doesnt end with the character(s) entered in the Edit box |
Not Including |
Doesnt contain the character(s) entered in the Edit box |
Not Like |
Isnt like the value entered as argument in the Edit box using wildcard such as ? and * |