Use criteria for conditional query--1.2. Specify multiple criteria

2. Specify multiple criteria

You can enter multiple criteria for the same field or for different fields. When you enter an expression in more than one criteria cell, Microsoft Access uses the and OR operator to combine. If this expression is in different cells in the same row, Microsoft Access uses the AND operator to indicate that records that match the criteria in all cells will be returned. If the expression is not in the design grid, Microsoft Access uses the OR operator to indicate that records that match the criteria in any one cell will be returned.

In the figure above, two criteria are on different lines, so Access will connect using the OR operator,
The equivalent of the rule in the last name paragraph is: "Zhang Beautiful" Or "Li Zhenhua".

This is the result of the query run, listing all the records of the driver named "Zhang Beautiful" and Li Zhenhua.