Help with query

  • Thread starter Thread starter James A
  • Start date Start date
J

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
 
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
 
JulieD said:
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
Click to expand...


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 !
 
Back
Top