Hi - don't use Access very often, not technically minded and its early in the morning - can you help please?
I have a table of Supplier Details which contains records for suppliers of products listed in a number of different tables. I need to extract a list of the suppliers who provide products listed in a table, but unfortunately that table does not have a Supplier ID field. The other tables do have Supplier ID fields. How can I create a query that will return only the records that DO NOT match a Supplier ID on any of the other tables?