title: Upserting in MS-access
body: <p>I need to write an SQL query for MS-Access 2000 so that a row is updated if it exists, but inserted if it does not. (I believe this is called an "upsert")</p>
  
  <p>i.e.</p>
  
  <p>If row exists...</p>
  
  <pre><code>UPDATE Table1 SET (...) WHERE Column1='SomeValue'
  </code></pre>
  
  <p>If it does not exist...</p>
  
  <pre><code>INSERT INTO Table1 VALUES (...)
  </code></pre>
  
  <p>Can this be done in one query?</p>