title: SQL query in Access update multiple fields
body: <p>Using MS Access, can I run multiple UPDATE statements in one SQL query?</p>
  
  <p>Say I have a table with columns A-F.
  What I want to do is this:</p>
  
  <pre><code>UPDATE table SET C = NULL WHERE C = 0
  UPDATE table SET D = NULL WHERE D = 0
  UPDATE table SET E = NULL WHERE E = 0
  </code></pre>
  
  <p>I understand that with SQL Server I could use a 'GO' after each line but that doesn't seem to work with Access.  Is there an alternative, or do I just have to run a load of separate queries?</p>