>Well, I would like to define them as one field. Unfortunately it doesn't work that way. In this case I use the orgtracnum,date,amount,bankname to define the record. even then I have noticed that things don't go well. You know the real world. It's real.

No kidding!

SELECT orgtracnum,date,amount,bankname, COUNT (*) AS DupCount;
    FROM TableWithDupes ;
    GROUP BY 1,2,3,4 ;
    INTO CURSOR Dupes ;
    HAVING COUNT (*) > 1

That should get you the "key" values of what you consider to be duplicate entries.

A correlated subquery would be the way to get full information from each of the duplicate records. However, it's a bit tricky to formulate when you have a composite key, and I don't remember off the top of my head how I resolved that last time.

HTH,

Jay