Access 2013 & 365 In Pictures
Employ a Wild Card character

1 Return to Design View.

2 Remove all query criteria from all fields.

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.

4 Close the Property sheet.

5 In the Company Name field, click in the Criteria row.