When you use the ____ comparison operator if a record's field value matches one value from the list of defined values then Access selects and includes that record in the query results.
A)As
B)Like
C)In
D)Or

Question

Quizplus · Accepted Answer

The "In" comparison operator is specifically designed to match a record's field value with a list of defined values. Using "In" in your query allows you to specify multiple possible values for a field and retrieve all records whose values match any of the values in the list. This saves you the time and effort of running separate queries for each individual value.

When You Use the ____ Comparison Operator If a Record's