Originally Posted by stell
So is the idea to use the matched query to use for a delete query and then delete the duplicates?
It would have been better still in the query section!
I hadn't noticed it was in Macros (which isn't really relevant!)
No - the unmatched
query wizard creates a SELECT query showing records in one table that don't exist in the other.
To use this, click Create ...Query Wizard ... Find Unmatched Query Wizard
Choose your source & destination tables & select the fields to be imported.
Identify a matching field in both tables which is used to check for matched records.
The result will look something like this in the query designer:
Once you have this, change it to an APPEND query (Design ... Append)
and select the destination table name.
The design will now look similar to this
IMPORTANT - you MUST remove the duplicate field name with the IsNull criterion as shown
Run the query to add new records without any duplicates