Finding An Unequal Match?

[CharlesWhiteman]

In My Db I have a couple of tables, TblEnquiries & TblTasks

Tasks are entered and in TblTasks the TblEnquiry.EnquiryID is used as the foreign key.

But I want to design a query which tells me which enquiries have no tasks in TblTasks.

Maybe I'm going brain dead but cant seem to do it!

Thanks All!

 

[RuralGuy]

Have you tried playing with the Unmatched Query Wizard?

 

[CharlesWhiteman]

There you are you see, I need to take a break and get my head back!!

Thanks

 

[RuralGuy]

Drop by any time.