Eric wants a query to select records with a HireDate field value greater than 12/31/2015 and a Position value of "Manager." Where should he place the conditions in the query design grid?
A) in the same Criteria row
B) in different Criteria rows
C) in the same field box
D) in a new column

Question

Quizplus · Accepted Answer

Eric should place both conditions in the same Criteria row to ensure that both conditions are applied together using an AND logic, meaning both must be true for a record to be selected.

Eric Wants a Query to Select Records with a HireDate