querying all entries in one table that aren't in the other one

[n.be...@gmail.com]

Hi,

I have 2 tables linked to each other by a field. I'd like to query all
the enteries in one table that aren't in the other one, based on that
field. Any suggestions?

[pietl...@hotmail.com]

Here's an example...
Customers is the table that always has values (because you can't have
an invoice without a customer). Say I want to see any Customers
without Invoices.

SELECT Customers.CompanyName, Invoices.InvoiceID
FROM Customers LEFT JOIN Invoices ON Customers.CustomerID =
Invoices.CustomerID
WHERE (((Invoices.InvoiceID) Is Null));

[Larry Linson]

<n.be...@gmail.com> wrote

> I have 2 tables linked to each other by a field. I'd like to query all
> the enteries in one table that aren't in the other one, based on that
> field. Any suggestions?

Is there some particular reason that you cannot use the "Find Unmatched
Wizard" in the Query Builder? In the Query Tab of the DB Window, click New,
then one option will be the "Find Unmatched Wizard".

Larry Linson
Microsoft Access MVP

[n.be...@gmail.com]

Thanks so much for all your help!