Page 4 of 9PREVNEXT

Queries V: Use And, Or, and In to set multiple conditions

Using the same condition in different fields

If you have more than one condition, and each condition applies to a different field, you still use the or cells. For example, you use this technique to find customers in either France or London.

Callout 1 Start by entering the first condition in the Criteria cell. In this case, it's France.
Callout 2 Because you need to find France or London, enter the second criteria in the Or field, like so.

Next, we'll look at the differences between the And and Or operators.

Page 4 of 9PREVNEXT