>>>>>>>>>>>>>>>>>>>>
>>Thanks Alex:
>>
>>That worked fine. BTW, how would I delete those records from the master.dbf after I created the duplicates.dbf?
>>
>>The final result being the master.dbf containing no dups and the duplicates.dbf containing all the dups.
>>
>>Thanks again.
>>
>>Peter
>
>Oh sure, I do almost all the work, Alex comes in and points out a minor typo, and gets all the credit < vbg >.
>
>Did you write earlier that the user will have to look over the duplicate records and decide which ones to delete? Do you have a way of uniquely identifying the records in TableName table, for example a CustomerID?
>>>>>>>>>>>>>>>>>>>>

It's allways something -- Roseane Roseannadanna