>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?
Chris McCandless
Red Sky Software