Not in Table Query

[Edgar Thoemmes]

I have a table of Suppliers that gets downloaded each month, New suppliers
are added each month and I want to design a query that will extract all new
suppliers from the list.

The following table holds supplier details which was downloaded last month:
tblSupplier(SuppID, SuppName, Address, Tel)

The following table holds all the info for suppliers downloaded this month
tblTEMPImport(SuppID, SuppName, Address, Tel)

I can use a query to show suppliers which appear on both lists but I cannot
seem to find a way to show suppliers which are in tblTEMPimport but not in
tblSuppliers.

Can anyone help?

Many thanks

 

[Tom Ellison]

Dear Edgar:

SELECT T.*
FROM tblTEMPImport T
LEFT JOIN tblSupplier S ON S.SuppID = T.SuppID
WHERE S.SuppID IS NULL

This should show all the "new" suppliers in the import table, based on
their SuppID numbers. Is this the correct way to define which are
new?

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

 

[Edgar Thoemmes]

Tom - thanks for the response, yes this is the correct way to define new
suppliers and it worked.