Use the OR criteria to query on alternate or multiple conditions

To see information when either two or more alternate criteria are satisfied, use the or criteria rows in the Access query design grid.

If you’d like a refresher, see applying criteria to a query.

For example, if a business has customers in several different countries and they are running a promotion only for customers in France, UK and USA. To get a list of customers from just these countries, here’s how you can use the OR row:

1. Open the table that you want to use as your query source and on the Create tab click Query Design.

2. In the Query Designer, select the table, and double-click the fields that you want displayed in the query results.

3. Add your first criterion in the Criteria row.

   Note:  Use the appropriate column, we’ve used the Country/Region in this example but if you want to locate specific last names, you’d add the criteria in the Last Name field.

4. Add the alternate criteria in the or row and if you have more than one use the empty rows below, and click Run.

5. Press CTRL+S to save the query.

Another example of the OR criteria:    Find employees who work in the Chicago branch office OR employees whose birthday falls on a specific date:

1. The City criterion is specified in the Criteria row.

2. The BirthDate criterion is specified in the or row.

Criteria specified in the Criteria and or rows are combined using the OR operator, as shown below:

City = "Chicago" OR BirthDate < DateAdd (" yyyy ", -40, Date())

It is possible to specify more alternatives, by using the empty rows below the or row.