pairing duplicate records in a table
Need help and know no to very little code.
Have a table DONORS that has assigned Soundex for finding possible duplicate donors. The fields I need to compare are Soundex,Lname.Fname,DOB,DonorId so that when I create a report from the query I can group possible duplicates in pairs to be researched to determine if they are actual duplicates are not.
I tried using the find duplicate records wizard to no avail.
I think I should be looking at using an Alias for the Donors table when the designing query. Need something like If Soundex and Lname and or DOB are same then pair these two where DonorId is not =.
Will be willing to e-mail table to anyone that might be able to help.
Thanks
RC
Need help and know no to very little code.
Have a table DONORS that has assigned Soundex for finding possible duplicate donors. The fields I need to compare are Soundex,Lname.Fname,DOB,DonorId so that when I create a report from the query I can group possible duplicates in pairs to be researched to determine if they are actual duplicates are not.
I tried using the find duplicate records wizard to no avail.
I think I should be looking at using an Alias for the Donors table when the designing query. Need something like If Soundex and Lname and or DOB are same then pair these two where DonorId is not =.
Will be willing to e-mail table to anyone that might be able to help.
Thanks
RC
Last edited:
