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