Need to D-Dupe between 2 diff tables???

  • Thread starter Thread starter Richard Albrecht
  • Start date Start date
R

Richard Albrecht

Hi,

Anyone have a good program that can detect dupes on fields I select between
2 tables?

TIA

Rich
 
How do you decide that records are duplicates.? One field, two fields, many fields?

You can put both tables into your query and set up relationships between up to
10 fields. You can then run the query and get all the records that match
between the two tables. Is that what you mean?
 
But what about trying to find out which records are NOT in common between two tables (e.g. for {X} = {A,B.C.D} and {Y} = {A,C,D} what is {X} - {Y})? There used to be a braincell-free way to do this in Access 97 using the Query Wizard (but, of course since I always took advantage of the wizard for this function I now find myself clueless as to how to implement it in newer versions of Access). I have a vague sensation that the Wizard did something in SQL but I cannot remember what

----- John Spencer (MVP) wrote: ----

How do you decide that records are duplicates.? One field, two fields, many fields

You can put both tables into your query and set up relationships between up t
10 fields. You can then run the query and get all the records that matc
between the two tables. Is that what you mean


Richard Albrecht wrote
 
Try using the Unmatched Query Wizard.

If it is not available.

Join on the relevant fields
Set the join to show the records in the table you are interested in
Add at least one of the fields in the second table to the select list and test
it for Is Null

SQL statement would look something like:

SELECT X.*
FROM X LEFT JOIN Y
On X.MatchField = Y.Matchfield
WHERE Y.MatchField is Null

That would return B for table X per your example.
 
Back
Top