Query results?

[jackie77]

Hi all

I am working on a query but can manage to get it to do what I want.
I have a main table with a job_ID and a faults table which documents faults that occur related to that Job_ID the tables are related with a one to many relationship. I want the query to bring up all the jobs even those with no faults, at present it is only bring up those jobs that have faults, how do I include details of all the jobs and if there are no faults then that field is left blank, probably very simple to do but after working on this db for hours my brain is no longer functioning!!

Thanks

Jackie

 

[ajetrumpet]

Please post the code of the query...

 

[jackie77]

Hi, thanks for the reply, but I managed to get it sorted out, I changed the relationship type in the query only and it now works fine, it was a silly question but my brain was fried!

thanks anyway

Jackie