title: MS access update query to update part of string
body: <p>I am trying to use an update query to update the first 3 characters of a string. but i am getting a syntax error</p>
  
  <p>my query is</p>
  
  <pre><code>update table1, table 2 set left(table1.stringfield, 3) = table2.stringfield
  </code></pre>
  
  <p>thankstksy</p>