Finding and Reporting Duplicates from two tables

[dpaul662]

Hey guys,

I have a situation. I have two tables with a list of names showing if they have completed a work, and not completed a work, the thing is some names are showing in both tables, so my boss wants me to pull the duplicates names from both tables and report them. i've tried the duplicate query wizard, but it only pulls duplicates from one table. i need it to compare the two tables and report the duplicates

 

[PHV]

Why not joining the two tables on the name fields ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[BDW1969]

Can you run the duplicates query wizard?