Query criteria based on values in Excel column

[jonman03]

Hello,

I need a way for a query to select all records based on the product numbers I have listed in an Excel column. I tried copy and pasting the Excel product numbers into the Criteria of the query, but it does not work properly. It pastes them "horizontally" rather than "vertically" (in the Or section).

What is the best way to do this? I have like 25 product numbers that I want returned by the query and have no other way to group/identify them except by the Product numbers in Excel.

I just need an easy way to use the product numbers in Excel as the query criteria.

Thank you!

 

[highandwild]

Create a one field table containing just the product numbers. You should have 25 records.

Link your existing table to the new table using the product number field
and that should just return the records in the main table whose product number is contained in the new table.