3 Left Joins on Query

[Guest]

I am trying to develop a query that will have 3 left joins...of course I get
the ambiguous error message, so I created it using all inner joins. Hoping I
can get some help to use left joins to the "Activity_tbl":

SELECT Calendar_tbl.Date, Account_Class_tbl.[Acct Class],
Acct_Type_tbl.[Acct Type], Count(Activity_tbl.Activity) AS CountOfActivity
FROM Acct_Type_tbl INNER JOIN (Account_Class_tbl INNER JOIN (Calendar_tbl
INNER JOIN Activity_tbl ON Calendar_tbl.Date = Activity_tbl.Date) ON
Account_Class_tbl.[Acct Class] = Activity_tbl.[Account Class]) ON
Acct_Type_tbl.[Acct Type] = Activity_tbl.[Account Type]
GROUP BY Calendar_tbl.Date, Account_Class_tbl.[Acct Class],
Acct_Type_tbl.[Acct Type]
HAVING (((Calendar_tbl.Date) Between [Forms]![Sales_Recap_frm]![Date1] And
[Forms]![Sales_Recap_frm]![Date1]-6));


I tried to just change the word INNER to LEFT...of course it wouldn't be
that easy...

 

[taurus via AccessMonster.com]

What are you trying to obtain that requires the left joins? Are the
account_class_tbl and acct_type_tbl validation / lookup tables for the
activity_tbl? If so, I am not sure why the query needs to have them
referenced.