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 * |