When you want to specify criteria in multiple fields,and at least one of the criteria must be true for a record to be included in the results,then the ________ logical operator is used.
A) AND
B) OR
C) NOT
D) BETWEEN

Question

Quizplus · Accepted Answer

The OR logical operator is used when you want to include records that meet at least one of the specified criteria in multiple fields. The AND operator would require all the specified criteria to be true for a record to be included, while the NOT operator would exclude records that meet certain criteria. The BETWEEN operator is used to retrieve records within a specific range.

When You Want to Specify Criteria in Multiple Fields,and at Least