title: How to remove BOTH duplicates in MS ACCESS
body: <p>Oh yes, MS Access...</p>
  
  <p>I have a table that contains duplicates and essentially if there are duplicates, I need to remove BOTH records.  Is this possible?</p>
  
  <p>To complicate things, what I am calling "duplicates" aren't truly duplicate across all fields, but they are across key fields.</p>
  
  <p>Here's the table (not formatted very prettily):</p>
  
  <pre><code>ID  documentDate    accountNetAmount    reference   accountTaxAmount    getBankAccount  getCompany  isReconciled    oid
  11  6/30/2013   20687.7 REFTe   0   02537.0000000014    02544.0000000023    1   02364.0000000078
  12  6/30/2013   -20687.7    EFTe    0   02537.0000000014    02544.0000000023    0   02364.0000000079
  13  6/30/2013   14935.41    REFTf   0   02537.0000000014    02544.0000000023    1   02364.0000000080
  14  6/30/2013   -14935.41   EFTf    0   02537.0000000014    02544.0000000023    0   02364.0000000081
  15  7/4/2013    -294.55 MIMOSA  -29.45  02537.0000000014    02544.0000000023    0   02364.0000000177
  16  7/8/2013    -1185.81    BPAY080713  -118.58 02537.0000000014    02544.0000000023    0   02364.0000000499
  17  7/9/2013    -462.05 PERFUME -46.2   02537.0000000014    02544.0000000023    0   02364.0000000179
  18  7/9/2013    -1264.09    PERFUMERY   -126.41 02537.0000000014    02544.0000000023    0   02364.0000000181
  </code></pre>
  
  <p>I need to remove records where the documentDate and abs(accountNetAmount) are the same. So my result set should look like this:</p>
  
  <pre><code>ID  documentDate    accountNetAmount    reference   accountTaxAmount    getBankAccount  getCompany  isReconciled    oid
  15  7/4/2013    -294.55 MIMOSA  -29.45  02537.0000000014    02544.0000000023    0   02364.0000000177
  16  7/8/2013    -1185.81    BPAY080713  -118.58 02537.0000000014    02544.0000000023    0   02364.0000000499
  17  7/9/2013    -462.05 PERFUME -46.2   02537.0000000014    02544.0000000023    0   02364.0000000179
  18  7/9/2013    -1264.09    PERFUMERY   -126.41 02537.0000000014    02544.0000000023    0   02364.0000000181
  </code></pre>
  
  <p>Any suggestions? And don't forget, MS Access... ugh.</p>
  
  <p>Thanks!</p>