Specifying additional criteria on query forms

In a query form, select the Additional Criteria tab.

From the first drop-down list box, select a field on which you want to filter.

In the second drop-down list box, select the operator you want to use.

For more information about the operators available, see Operators on Query Forms.

In the third field, enter a value that you want to use as the search criteria. Remember that:

You can use the wildcard character to match unspecified characters.
To find records containing a null value in the field, you can enter the Null keyword.
To use the Null keyword, the operator must be = (equals). To find records in which the field is not null, use the Null keyword with the <> (not equal) operator.

For more information about the Null keyword, see Using the Null Keyword.

To find records compared to the current date, you can use the CURDATE() keyword. See Sample Queries for more information.

Alphabetic input is not case-sensitive.

Specify whether to join the current query clause with the previous clause by AND or OR:

To use OR, select the check box labeled OR instead of AND with previous clause.
To use AND, clear the check box labeled OR instead of AND with previous clause.
If the current clause is the first clause you have defined for the query form, accept the default, which is AND.
If you specified any primary criteria, be sure to select AND or OR according to how you want to join the current clause with the primary criteria.

Click Add. The system adds the clause to the list.

Repeat steps 2-6 for each additional clause.

Optionally, to remove a clause from the list, select the clause and click Remove.