To achieve AND effect when you are entering criteria in a query design window

• write criteria values vertically one in a row

• write criteria values horizontally

• Write criteria values in same field separated with AND

• Write criteria values in same field separated with &

...
Explanation: You can add an explanation to this Question by commenting below :) Please Contribute!