I am trying to write a query in VB for an Access Module and keep getting an error on the join. Specifically "Join expression not supported."
Here is the text I an assigning to the ADO command : "INSERT INTO CTimeReportTbl ( Timecard!EmpID, TimeCardHours!ateWorked, TimeCardHours!Minutes, TimeCardHours!RateIDLookUpTimeCardHours! CompCode ) SELECT TimeCard!EmpID, TimeCardHours.DateWorked, TimeCardHours!Minutes,TimeCardHours!CompCodeLookUp FROM (TimeCard INNER JOIN TimeCardHours ON TimeCard!TimeCardID = TimeCardHours! TimeCardID) WHERE (((TimeCard!EmpID) = [Forms]![TC_Select_Form]![EmpID Combo]) And ((TimeCardHours!CompCodeLookUp) = 'CTA' Or (TimeCardHours! CompCodeLookUp) = 'CTU')) ORDER BY TimeCard!EmpID, TimeCardHours! DateWorked;" Your help is greatly appreciated!
