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.