Query with Multiple Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to pull a query but I have 300+ individual items to pull. These are
part numbers. I do not want to type them into the criteria row one by one.
How do I accomplish this project? They are currently residing in an excel
spreadsheet. Can I export them into Access as a table and then call the
table? If so, how do I call the table for each part number.

queryname: Item Number
field: Item
criteria:

Tablename: Inventory (300+ items here)
ColA: Item

Thanks!
 
Hi,

If the Excel worksheet looks like a table, with the needed data all in one
column, it should be easy enough.

First of all just link to the Excel spreadsheet by going to File, Get
External Data, Link Tables. Make sure to look for XLS files.

Now you can use the linked spreadsheet as a table. Open up a new query and
bring in both the linked table and the one that you wish to query. Drag and
drop a link between the two tables with the appropriate fields. Then bring
down the appropriate fields to the grid. When you run the query it should
only return records that are in both linked fields.
 
Back
Top