I needed to find a suitable example rather than trying to explain from scratch.
Have a look at this post
http://stackoverflow.com/questions/19367565/sql-inner-join-wih-multiple-table[
^]
(I know it says "sql" but it is for Access)
You can "trick" access into thinking that it is only joining two "tables" using the technique shown at that link
[Edit] - if this doesn't solve your problem, goto the SQL View in access and copy your query into your post and I'll try again