Conditional Duplicate Removal

[jimart]

I have a Table consisting of Marriages - Surname & Firstname of Groom & Surname & Firstname of Bride - The table has many duplicates - I need to remove Excess Grooms that have the same names & are married to the same person & leave any that have the same name But are married to a different person.

Any help gratefully received

 

[neileg]

Use the Find Duplicates query wizard.