Re: 3 table join

["paross1" <webforumsuser@xxxxxxxxxxxxxx>]

Access is rather picky/demanding with the use of parantheses, especially with 
OUTER joins. It has been too long for me since writing such queries in Access 
for me to tell you exactly where to place your ( )'s, but you will need to 
group your clauses with them to avoid these errors.

 Phil