Can I use a table as the criteria in a query?
I have multiple queries that do different things but they all need to identify if the part number is a kit or a stand alone part.
The problem is the list of kits is growing and every time a new kit is added I have to go in to *ALL* the queries and add the new item number.
So my question is can I use a table with the kit part numbers as my criteria?
Currently I am using an IIf statement to designate if the item is a kit or part.
example: IIf([Ordered Item] Like "ABC-*" Or [Ordered Item] Like "DEF-*" Or [Ordered Item] Like "GHI-*" ,"KIT","PART")
If I could use a table I would only need to update one location. Or does anyone have a different idea?