I am getting a run-time error (Syntax error in Join expression ) when trying to use the following coding:



Here is how this statement looks when I print it out:

SELECT tblUser!LastName & ', ' & tblUser!FirstName AS MDM, [Requirements Status].RequirementsStatus, Count(tblRequirementsActivityDetail.RequirementsActivityDetailID) AS CountOfRequirementsActivityDetailID FROM [Requirements Status] INNER JOIN (tblRequirementsActivityDetail ON [Requirements Status].RequirementsStatusID = tblRequirementsActivityDetail.StatusID) INNER JOIN (Job_Requirements ON [Requirements Status].RequirementsStatusID = Job_Requirements.RequirementsStatusID) INNER JOIN (tblClients ON Job_Requirements.Client_Contact_ID = tblClients.Client_Contact_ID) INNER JOIN (tblUser ON tblClients.MDM = tblUser.UserID) WHERE (((tblUser.UserID) = [Forms]![frmMDM]![Combo10])) GROUP BY tblUser!LastName & ', ' & tblUser!FirstName, [Requirements Status].RequirementsStatus ORDER BY tblUser!LastName & ', ' & tblUser!FirstName, [Requirements Status].RequirementsStatus;


Any help would be greatly appreciated.

Kevin

Try modifying the second line of code thus:

Thank you very much.