If you want the results of a query to display only those records that meet all criteria,you would use the ________ operator.
A)OR
B)NOT
C)AND
D)NOR

Question

Quizplus · Accepted Answer

The AND operator only selects records that meet all of the criteria specified in the query. Therefore, it is the best choice to display only those records that meet all criteria. The OR operator selects records that meet any of the criteria, while the NOT operator selects records that do not meet the criteria. The NOR operator is not a valid logical operator in this context.

If You Want the Results of a Query to Display