Specify certain criteria to be met for a record to be placed in the dynaset. To specify criteria for a query, use an expression. The expression tells Access which records to include in the query's dynaset. Entering Expressions Specify criteria by typing the expression in the Criteria cell in the field's row on the QBE grid. For the complete list of rules on expressions, consult Access' on-line Help.
Access assumes that each extra Criteria row under the first one uses an Or operator.
Access reads across each row of criteria from left to right, then starts moves down row by row. In order to combine your searches, you would need to know which items should go on the same row. The format for entering wildcards differs slightly from entering complete data. Access inserts the Like command before the entered expression. The following examples show various range operators.