SELECT * ; FROM january ; WHERE orgtracnum IN ; ( SELECT orgtracnum, ; FROM january ; WHERE NOT EMPTY(orgtracnum) ; GROUP BY orgtracnum ; HAVING COUNT(*) > 1 ) ; Order BY orgtracnum, amount ; INTO table alldupes>I still have not really found a routine to find duplicates that works for me.
>SELECT settdate, amount, orgtracnum, ; > COUNT(*) AS dupes, bankname ; > FROM january ; > WHERE NOT EMPTY(orgtracnum) ; > GROUP BY january.orgtracnum ; > HAVING dupes > 1 ; > INTO table duplicates > > SELECT * ; > FROM january ; > WHERE orgtracnum IN ; > (SELECT orgtracnum FROM duplicates) ; > GROUP BY orgtracnum, amount ; > INTO table alldupes>It finds the duplicates but it also sticks in things that almost match.