Access 2007 In Pictures

Employ the AND operator
  1. Return to Design View.
  2. Remove the query criteria from the State field.

    (Highlight them, then press the DELETE key.)

    The Criteria row in the design grid should be blank: