title: Access Removing CERTAIN PARTS of Duplicates in Union Query
body: <p>I'm working in Access 2007 and know nothing about SQL and very, very little VBA.  I am trying to do a union query to join two tables, and delete the duplicates.</p>
  
  <p>BUT, a lot of my duplicates have info in one entry that's not in the other.  It's not a 100% exact duplicate.</p>
  
  <p>Example,<br>
  Row 1: A, B, BLANK<br>
  Row 2: A, BLANK, C</p>
  
  <p>I want it to MERGE both of these to end up as one row of A, B, C.</p>
  
  <p>I found a similar question on here but I don't understand the answer at all.  Any help would be greatly appreciated.</p>