>I plan to do that for the future.
>
>I still need a way to find to duplicates and get rid of them.
If you only want to detect the duplicates, and do the cleaning-up manually, use a SELECT statement:
select *, count(*) as _count;
from MyTable;
group by KeyField1, KeyField2, KeyField3;
having _count > 1
The combination KeyField1, KeyField2, KeyField3 is supposed to be unique in this example.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
