List unmatched FIELD NAMES

[pvg]

Problem: Compare 2 tables and list the unmatched FIELD NAMES.<br>While the unmatched query wizard in Access offers multiple fields to select, the result is only a list of null records and it does not show which FIELD NAMES are unmatched.<br>For example:<br>Table1<br>---------------------------------------------<br>Field Names:<br>Uniquekey.Name......Addr...Phone....EnteredBy <br>---------------------------------------------<br>12345.....JoeSmith..123Elm..742-6666.pvg<br><br>Table2<br>---------------------------------------------<br>12345.....JohnSmith.123Elm..742-6666.mhw<br><br>Notice in the example above that Operator pvg entered Joe Smith for record 12345 and Operator mhw entered John Smith.<br>We need the query to show that the &quot;NAME&quot; FIELD did not match for Uniquekey 12345. We ignore the EnteredBy field because the data is supposed to be entered by 2 different operators.<br><br>The report could look like this:<br><br>Table 1 and Table 2 match report<br>--------------------------------<br>..................UNMATCHED<br>Uniquekey.........FIELD Name<br>-------------------------------------<br>12345...............NAME<br><br>Table 1 count: 1<br>Table 2 count: 1<br>Unmatched : 1<br><br>Thanks in advance for your help.<br>

 

[Guest_imported]

make query with both tables<br>inner join on the unique key<br>insert name and uniqueid criteria from table 1 in qbe grid<br>place &lt;&gt; [table2].[name]in the criteria uner name

 

[Guest_imported]

Incorrect post on 1st try&nbsp;&nbsp;you want to use a left joinnot inner