title: Ms Access SQL VBA query error no 3075
body: <p>In my Access application, I am trying to concat existing field value with new value and I have code as below written in VBA, I am getting error 3075 "syntax error missing operator"</p>
  
  <pre><code>sUser = UserNameWindows
  '    MsgBox sUser
      currenttime = Format(Now(), "dd/mm/yyyy hh:mm:ss")
  SqlQuery = "UPDATE tbl_AllRequests " &amp; _
  " SET [Status]= 'Archived' " &amp; _
  ", [History] = [History] &amp; CHR(13) &amp; CHR(10) &amp; 'Archived on' " &amp; currenttime &amp; " ' by ' &amp; '" + sUser + "' " &amp; _
  " WHERE [ID] in (" &amp; selectedIDs &amp; ")"
  '" SET [History] = concat([History], 'Archived on " &amp; currenttime &amp; " by '" &amp; sUser &amp; "'&amp;')'&amp;" &amp; _
  'data=concat(data, 'a')
  'SqlQuery = "UPDATE tbl_AllRequests SET Status = 'Archived' WHERE ID in (17, 11)"
  Debug.Print "this is new one " &amp; SqlQuery
  DoCmd.RunSQL SqlQuery, True 
  </code></pre>
  
  <p>I am getting error on below line of code.</p>
  
  <blockquote>
  <pre><code>", [History] = [History] &amp; CHR(13) &amp; CHR(10) &amp; 'Archived on' " &amp; currenttime &amp; " ' by ' &amp; '" + sUser + "' " &amp; _
  </code></pre>
  </blockquote>
  
  <p>If I remove the code after 'Archived on' it works.</p>
  
  <p>Thanks</p>