title: MS Access query WHERE NOT EXISTS
body: <p>I have been looking around and haven't been able to make this work out.</p>
  
  <p>I have two tables resultant from two queries</p>
  
  <pre><code>SELECT [Account Combination].[Account Number] &amp; [Account Combination].[Cost Center] &amp; [Account Combination].Amount as Val1 FROM [Account Combination];
  </code></pre>
  
  <p>AND</p>
  
  <pre><code>SELECT [Account Combination].[Account Number] &amp; [Account Combination].[Cost Center] &amp; [Account Combination].Amount AS Val1 FROM [Account Information] INNER JOIN ([Cost Center] INNER JOIN [Account Combination] ON [Cost Center].[Cost Center Number] = [Account Combination].[Cost Center]) ON [Account Information].[Account Number] = [Account Combination].[Account Number];
  </code></pre>
  
  <p>Table1 has 1800 rows and Table2 has 1600. I would like to read which are found in Table1 and not found in Table2, the 200.</p>
  
  <p>I have tried the Table1 NOT EXISTS Tabel2 but haven't been able to make it work properly as I get syntax error all the time.</p>
  
  <p>Thank for your time,
  Simon.</p>