Query excluding related table

[jb]

Re: tblCustomers, tbl Invoices, joined one-to-many on
RECORD NUMBER.

The Customers table includes "potential" customers,
people who who haven't actually ordered anything yet, and
so have NO related records in the related Invoice table.
I know how many of these there are by simple subtraction,
but how can I select records for Customers whose RECORD
NUMBER is NOT joined to the Invoices table?
Thanks.

 

[jb]

Thank you so much, that was easy. The only difference
from what I did is that this query has no RECORD NUMBER
showing from the original field. Otherwise it looks
esactly like what the one I created myself, with "is
Null" in the Criteria for Record Number in Invoices, that
didn't work. I wonder, is the Wizard is doing something
additional that isn't visible?
jb