Multiple criteria added to the same line of the query design grid means that each must be true for the record to appear in the datasheet.

Name: Multiple criteria added to the same line of the query design grid means that each must be true for the record to appear in the datasheet.
Brand: Quizplus
Rating: 4.7 (36 reviews)

Question

Quizplus · Accepted Answer

When multiple criteria are added to the same line in the query design grid, it means that all those conditions must be met (logical AND operation) for a record to be included in the query results.

Multiple Criteria Added to the Same Line of the Query