In Access, we can only join two tables, in order to join more tables you require to group the first join together by using parentheses, as if it was a newly derived table. After that, you can join another table to that group.
Select * from((Table 1
LEFT JOIN Table 2…
LEFT JOIN Table3…)
LEFT JOIN Table4…
If you like this question & answer and want to contribute, then write your question & answer and email to freewebmentor[@]gmail.com. Your question and answer will appear on FreeWebMentor.com and help other developers.