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