Retrieve records that include one value from a list of values using a query

1. In query Design view, create a query. Add the tables whose records you want to use, and then add the fields you want to include in the results to the query design grid.
   
   
2. In the Criteria cell of the appropriate field, type an expression using the In operator. For example, to find suppliers located in France, Germany, or Japan, type the following expression in the Criteria cell for the Country field of the Suppliers table:

   In(France,Germany,Japan)

   You can also enter:

   France Or Germany Or Japan