>A while back I asked for help in finding duplicate records. I've worked this job for a week and I have better information to give. This is an auditing application. First, there are several million records in the table. The auditors want to look for records where several of the fields either match or maybe values were transposed (like vendor number and transaction number or invoice number). They want to search the table an only return a set of records where there are not just unique records (one of everything), but where two or more records meet the criteria. Suggestions?

First, I suppose You can Success to Select all Duplicate Records.
i.e.
Select Count(*) as RepeatTime, Key1, key2, key3, ... from MyTable ;
Group By Key1, Key2, Key3 ;
Having RepeatTime > 1 ;
into Cursor GotRepeat

and set it on grid.recordsource to show.

I have an idea on finding it, it mainly comes from DupCheck.exe in this FILE
Section.

Find it and Download, use it. Much faster!! ^_^'

My idea is similar, take all repeating Key into Cursor or Array Variable.

Then, take it one-by-one and select it again!!

e.g. if you use ArrayRepeatKey1[] to carry the repeating Key1.

Just use another grid to give:

Select * from MyTable ;
Where Key1 = ArrayRepeatKey1[1]

* Or Sth Key1 in ArrayRepeatKey1[], But Need other expertise here
to give the Correct syntax la.... Because My coding technique is poor..
~~>_<~~

Anyway, If you have dupcheck, I suppose you no need to handle any method,
but use it!! :D=====