title: Query for MS Access to insert record if not exists
body: <p>Here is a MySql query which is fine, but it does not work on MS-Access: </p>
  
  <pre><code>INSERT INTO ProcedureCodeModifier (ProcedureCode, Description)
  SELECT * FROM
  (
      SELECT 'A1', 'Dressing for one wound'
  ) AS tmp
  WHERE NOT EXISTS (SELECT ProcedureCode FROM ProcedureCodeModifier
                    WHERE ProcedureCode = 'A1')
  LIMIT 1;
  </code></pre>