View Full Version : Find duplicates when 2 fields in table (added together) are same for 2 rows


WebFaktor
05-31-2002, 12:37 PM
Is it possible to find duplicates via 'Find Duplicates Query Wizard' or otherwise, when two fields in table (added together) are the same for two rows?

I'm sorry to ask this - as the answer may already exist within forum - yet I'm pressed for time to complete!!!

Much thanks,

Michael

llkhoutx
05-31-2002, 10:50 PM
Build a query with the two fields summed in a third field. Then run the dup query wizard on that query, that is, the third field.

[This message has been edited by llkhoutx (edited 05-31-2002).]