title: How do I add records from one table missing in another table : MS Access
body: <p>Ok this should be easy.</p>
  
  <p>As an example,
  I have a table (TABLE 1) populated with the following records:</p>
  
  <pre><code>Account#  TrxDate  Description  Amount
  123456    20130719  trx-1       500.00
  123456    20130819  trx-2       500.00
  </code></pre>
  
  <p>I have a second table (TABLE 2) populated with the following records:</p>
  
  <pre><code>Account#  TrxDate  Description  Amount
  123456    20130719  trx-A       500.00
  123456    20130819  trx-B       500.00
  123456    20130919  trx-C       500.00
  </code></pre>
  
  <p>I want to add the last record in TABLE 2 to TABLE 1.</p>
  
  <p>I thought I could do this using WHERE NOT EXISTS but that isn't getting the job done.</p>
  
  <p>Here is an example of what I was trying that didn't work:</p>
  
  <pre><code>INSERT INTO Table1 (Account#, TrxDate, Description, Amount)
  SELECT Account#, TrxDate, Description, Amount
  FROM Table2
  WHERE NOT EXISTS
  (SELECT * FROM Table1 WHERE Table1.Account# = Table2.Account# AND Table1.TrxDate = Table2.TrxDate AND Table1.Amount = Table2.Amount)
  </code></pre>
  
  <p>Any suggestions?  Thanks in advance!</p>