update SQL

[Mark]

I am tring to update part of linked field, but I'm having
problems with the syntax. Here is the code I have been
working with, any ideas would be appreciated

"UPDATE tblAssignment AS a SET a.Left(([LogNumber]),6) = "
& txtLogNumber &
" WHERE a.JoinLogNumber = " & txtUpdateLogNumber

Thanks

Mark

 

[Chetan Satsangi]

if LogNumber is a string type field then you have to apply single quote( ' )
on both side of txtLogNumber like

......SET a.Left(([LogNumber]),6) = '" & txtLogNumber & "' WHERE.....

if LogNumber is numeric type then you can not use left function


chetan