title: UPDATE statement with multiple WHERE conditions
body: <p>I'm trying to run an <code>UPDATE</code> query in Access with different <code>WHERE</code> conditions:</p>
  
  <pre><code>UPDATE Table1
  SET [Ticker] = "TXSFI" WHERE [Acct Numb] like "*03",
  SET [Ticker] = "TESEI" WHERE [Acct Numb] like "*04";
  </code></pre>
  
  <p>Why do I get an error?</p>