Hey guys,
I just can't get this query to work. I'm not sure what's wrong with it.
Any ideas?Code:DoCmd.RunSQL ("UPDATE ec SET ObstructedView = EventPrep.Club_1_Check FROM " & vEventID & "_C ec INNER JOIN EventPrep ON ec.EventID = EventPrep.EventID WHERE ec.SubscriberType='Club' OR ec.SubscriberType='Bar';")
The error I get is telling me: "Syntax error (missing operator) in query expression '54fdsf' FROM EUC0412_C ec INNER JOIN EventPrep ON EUC0412_C.EventID = EventPrep.EventID