How to handle more than 64 criteria's in a query

[graphage]

I am working with a large database of items that we sell (50,000 items). I have been given a list of about 1000 random items that need be be removed. It seems to me that the max number of items I can enter into a query is 64. I also tried to go into the sql (rather than the regular query window), but I still seemed to hit the limit. Is there any way around this? I don't want to have to creat 15+ queries.....

Thanks in advance!

 

[Norie]

Do you have the items you want to remove in another table?

If you do you could join the existing table with that on the ItemID (or whatever the common unique identifier is) and then use that to delete records.

 

[graphage]

I can put them in a table....I'm not sure what to do after that....

 

[Norie]

Can you give more information?

How is your data is structured?

Does each product have a unique ID?

What are you actually trying to delete?

 

[graphage]

For simplicity, this is what I have:

MasterItemTable: Item#, ItemDesc

ExclusionTable: Item#

An item number is 6 digits long and they are each listed one time. I need to delete the line that represents the item.

 

[Norie]

How about this?

DELETE MasterItemTable.ItemID, MasterItemTable.ItemDesc
FROM MasterItemTable
WHERE (((MasterItemTable.ItemID) In (SELECT ExclusionTable.ItemID
FROM ExclusionTable));