Creating a comparison report of 2 different tables

[paulfla]

I have two different tables that have the same structure. I want to create a report that will display only those rows that may be potential duplicates. Duplicates being based on first name and last name columns.

The tables contain a person's record id, first name, last name & address information.

The report would show the information from the "temp" table and right below it the "live" table's information for each potential duplicate row. It would look something like below:

_______________________
Temp: Bob Smith, 1234 Main, Any, OH .....other columns..
Live: Bob Smith, 1234 Main, Any, OH .....other columns..

Temp: Cindy Zane, 34 S. Main, Mel, MI .....other columns..
Live: Cindy Zane, 234 Lewis Ave, Monroe, MI ..other columns..

** end of report **

_____________
How would I do that?

Thank you for your time in advance,
Paul

 

[67peshawar294]

Paul,
First, are the tables related? If so create a new query, if not create a relationship. Select the fields you want to compare from both tables;
Temp Firstname
Temp Lastname
Temp Address
Live Firstname
Live Lastname
Live Address
Save the query as you wish TmpLiveDups or similar.
Go to "queries","New","Find duplicates query wizard". Choose the TmpLiveDups and follow the instructions.
The spelling in each sililar field must be the same to find the duplicates.
Create a report.
If they are not related I'm not sure how to do it...
Jim