Get unique data from 2 tables

[Dhan119]

I receive weekly reports with same columns.. I need to extract the differences from both tables. Essentially this is an HR roster and I need to determine the new additions for this week along with extracting any other changes in the 2 roster's on any of the other columns.. There are over 40 columns but I need to get any changes in 6 or so columns along with getting any new record.

[Micron]

Did you try the Unmatched Query Wizard (as long as the new and old sources contain a field with the same data)? I guess that can't be an employee id if you're trying to find new people, but something else could be similar. I realize the wizard only provides for 4 fields, but I'm pretty sure I've started with that in the past and got something working, then edited the sql to simply add fields. You may have to combine an unmatched query/queries with UNION queries. I believe the individual queries that make up the UNION query are able to make use of the unique values or unique records property as well, which is something you might have to incorporate.