Access 2007 In Pictures

Employ a Wild Card character
  1. Return to Design View.
  2. Remove all query criteria from all fields.

    The design grid should be blank:

  3. Add the Company Name field to the query:

    Drag it from the field list in the Customers table and drop it in the blank field to the right of the State field.