Query returns nothing when I add a fourth table...

[Grooz13]

Ok I found the problem to my query... I have 4 tbl
Tbl_Submission
Tbl_Production
Tbl_Order
Tbl_Paint

When I query data from the first three tables , it returns my data alright... in the query design. I want to add data from Tbl_Paint, I only Show the Tbl_Paint didn't even add any data in the query from tbl_Paint and now my query return nothing... where is the problem ?

 

[vbaInet]

Change the joins to include all records from the main table. Do it for all joining lines.

 

[Grooz13]

will it change anything in my other query I did in my database ?

 

[vbaInet]

If you're only doing it in the query it will only affect the query and not your tables.

 

[Grooz13]

thank you very much you are the best it works now

 

[vbaInet]

Glad to hear