Find duplicates when 2 fields in table (added together) are same for 2 rows (1 Viewer)

[WebFaktor]

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]

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).]