Operators on Query Forms
Query forms support the comparison operators that are listed in this table:
| Operator | Description |
|---|---|
| Like | Returns records containing a field value that matches the value you type using one or more wildcard characters. See Using Wildcards. If you do not use a wildcard character, Like acts the same as = (equals). This is the default operator for the Primary Criteria tab fields. |
| = (Equals) | Returns records containing a field value that matches exactly
the value you type.
You cannot use wildcard characters with this operator. |
| > (Greater than) | Returns records containing a field value greater than the value
you enter. With letters, > refers
to alphabetical order from A to Z. This entry is not case-sensitive.
You can use wildcard characters with this operator. |
| < (Less than) | Returns records containing a field value less than the value
you enter. With letters, < refers
to alphabetical order from A to Z. This entry is not case-sensitive.
You can use wildcard characters with this operator. |
| <> or != (Not equal) | Returns records containing field values that do not match exactly
the value you specify.
You cannot use wildcard characters with this operator. |
| Not like | Returns records containing a field value that does not match
the value you type using one or more % wildcard characters.
If you do not use a wildcard character, Not like acts the same as <> or != (Not equal). Not like is not included in the list of operators, but you can type Not like in the operator field. |