Using Microsoft Access to create a select query with multiple criteria (all of which you want satisfied at the same time), you should specify them on the same Criteria line of the query.

Question

Quizplus · Accepted Answer

In Microsoft Access, when creating a select query with multiple criteria that must all be satisfied, you place them on the same Criteria line to apply the AND logic.

Using Microsoft Access to Create a Select Query with Multiple