Help with query

[James A]

I have two Tables:


(table 1)Projects:

[Jobno] [JoBName]
1 First project
2 Second project
3 Third project
4 Forth project


(table 2)Invoices:


[InvoiceNo] [Jobno]
1 1
2 1
3 1




I want to be able to write a query that will pickup all the jobs that
have NOT been
invoiced.


Eg, the result for the query should be:


[Jobno] [JoBName]
2 Second project
3 Third project
4 Forth project



I'm able to create a query easily enough that lists only the jobs that
HAVE been invoiced, the join constraints see to that.

I'm not sure if i'm supposed to create a nested query or change the
join constraints, I have done the latter without success.

Looking at this problem it seems to be fairly straightforward query.

Thanks for the help.

James

 

[JulieD]

Hi James

in the queries section click on the New button and have a look at the
unmatched queries wizard - this is designed to do what you want.

if its not there, post back as there is another way to do it also.

cheers
JulieD

 

[James A]

Hi James

in the queries section click on the New button and have a look at the
unmatched queries wizard - this is designed to do what you want.

if its not there, post back as there is another way to do it also.

cheers
JulieD

Thank you julie, I had previously searched around in help for some
period of time, didn't think of trying the wizard.

so, so easy !