update SQL

  • Thread starter Thread starter Mark
  • Start date Start date
M

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
 
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
 
Back
Top