Attempting to run the Category Summary Report but receive the following error message. I thought it might be an issue with missing quotes around the strWhere variable but no go. Any ideas? Thank-you in advance for any assistance.
Error Type:Microsoft JET Database Engine (0x80040E14)Syntax error (missing operator) in query expression 'tblCases.CatFK = tblCategories.CatPK LEFT OUTER JOIN (SELECT tblNotes.CaseFK, ISNull(SUM(tblNotes.MinutesSpent),0) as MinutesSpent FROM tblNotes GROUP BY tblNotes.CaseFK) as tblNotes ON tblCases.CasePK = tblNotes.CaseFK ' strWhere ''./liberum/www/rptCategorySummary.asp, line 77