Question

Differentiate between simple criteria and multiple criteria.​

Answer 1

Answer:

Using multiple criteria

• Criteria on the same row are implicitly joined by AND. ...
• Criteria on different rows are joined by OR. ...
• When you use multiple rows for criteria, the expressions on each row are treated as though they are joined by AND, but each row's worth of criteria are treated as though they are joined by OR.

Answer 2

Answer:

Criteria on the same row are implicitly joined by AND. Criteria on different rows are joined by OR. When you use multiple rows for criteria, the expressions on each row are treated as though they are joined by AND, but each row’s worth of criteria are treated as though they are joined by OR.