How to compare two tables?

B

Bill_S

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

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]
 
Top