When you want a record selected only if two or more conditions are met, you need to use the And logical operator. If you place conditions in separate fields in the same Criteria row of the design grid, all conditions in that row must be met in order for a record to be included in the query results. However, if you place conditions in different Criteria rows, a record will be selected if at least one of the conditions is met.
