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?

Thanks
Davie