BillTr
asked on
access vba inner join update
Syntax error. I need some help with an inner join in vba. Newbie stuff.. Thx
sSql = "UPDATE CData INNER JOIN pdata_positions ON (pdata_positions.Field13 = CData.ID) SET CData.name = pdata_positions.name;"
Db.Execute sSql
ASKER
Sorry, that is giving me a runtime error 3075
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
My solution was valid... but hnasr improved on it.
Kelvin