Or , and Not operators. And function allows you to specify two or more criteria for selection. The Or operator lets you specify two or more criteria, and your data must meet at least one of the criteria. The Not operator simply eliminates certain criteria from consideration. Commonly, you will use some combination of these operators.
Access assumes that each extra Criteria row under the first one uses an Or operator.
And and Or operators at the same time. You can combine the above operations. 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.