title: Excluding data pairs from a query based on a table?
body: <p>I have a massive and messy database of facilities where there are many duplicates. Addresses have been entered in such a haphazard way that I will be making many queries to identify possible duplicates. My objective is for each query to identify the possible duplicates, and then a person actually goes through the list and marks each pairing as either &quot;not a duplicate&quot; or &quot;possible duplicate.&quot;</p>
  <p>When someone marks a facility pair as not a duplicate, I want to record that data pair in a table so when that when one of the queries would otherwise return that pairing, it is instead excluded. I am at a loss for how to do this. I'm currently using MS Access for SQL queries, and have rudimentary visual basic knowledge.</p>
  <p>Sample of how it should work
  Query 1 is run to find duplicates based on city and company name. It brings back that facilities 1 and 2, 3 and 4, 5 and 6 are possible duplicates. The first two pairings are duplicates I need to go fix, but that 5 and 6 are indeed separate facilities. I click to record that facilities 5 and 6 are not duplicates, which records the data in a table. When query 1 is run again it does not  return that 5 and 6 are possible duplicates.</p>
  <p>For reference, the address duplicates look something like this, which is why there need to be multiple queries</p>
  <pre><code>Frank's Garage, 123 2nd St
  Frank's Garage LLC, LLC, 123 Second st
  Frank's Garage and muffler, 123 2nd Street
  Frank's, 12 2nd st
  </code></pre>
  <p>Any help is much appreciated!</p>