G Guest Jan 14, 2005 #1 Is there a straightforward way to compare two tables and write out the records that don't match to a third table?
Is there a straightforward way to compare two tables and write out the records that don't match to a third table?
J John Vinson Jan 14, 2005 #2 Is there a straightforward way to compare two tables and write out the records that don't match to a third table? Click to expand... Create a new Query based on your table; use the "Unmatched Records Wizard". Base an Append query upon this query. I don't see why this would ever be a useful thing to do, however! John W. Vinson[MVP]
Is there a straightforward way to compare two tables and write out the records that don't match to a third table? Click to expand... Create a new Query based on your table; use the "Unmatched Records Wizard". Base an Append query upon this query. I don't see why this would ever be a useful thing to do, however! John W. Vinson[MVP]