show table 1 field that has no corresponding table 2 field

[AaronG]

I'm running Office 2000 on Win2k.

I'm running a contact database that includes invoicing.
The two tables involved are "tbl_clientinfo"
and "tbl_invoice". I want to be able generate a report on
all clients in tbl_clientinfo who have not been invoiced
in tbl_invoice.

I was thinking that maybe I could pull up all clients that
don't have any record created yet (but I don't know how to
do that) OR I could have it automatically create an
invoice for all clients (which I don't know how to do) and
then filter by a date field or something like that.

Thanks in advance for all your help.

 

[Cheryl Fischer]

Select New Query and you will see in the wizard's list a "Find Unmatched
Query". Just follow the prompts and you will have it.

 

[AaronG]

Thanks, but I run into problems with this. I should have
been a little more detailed in my message. I have to
invoice clients every year, so they have a history, which
voids using the "Is Null" on the matching field.

Here's what I need. I need to know which clients have not
been invoiced yet this year. Since they haven't been
invoiced, there is no corresponding record for this year
to work from. This is where I get lost.

Thanks again for helping.

AG

 

[Jeff Boyce]

Aaron

So, you have a list of clients (as a query). And you have a list of clients
(as a query) who DO have an invoice, where Year = something.

Cheryl's answer is the answer -- do an "unmatched" query between the two.
You want folks in the first list (clients) who are not in the second list
(clients with invoices for Year = something).

Good luck!

Jeff Boyce
<Access MVP>