model table for a query

[munda1]

Hello,
I am importing a list of part numbers from Excel to Access, and creating a model table. The data base contains a preexisting table of all part numbers, I will call this a master table. I wish to write a query that will use the imported model table and extract every occurence of each of the entries from the imported table from the master table, creating a table with the results of the query. Can you help. Thanks,
Munda

 

[PHV]

Create a maketable query based on the imported table joined to the master table

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244