I know that I can create a unique.dbf from a dbf file that contains all unique records based on one field or multiple fields.

But how would I create a dbf (using a query) that would give me a table with all duplicated files. For example if a record appeared 3 times I would like to have that in a seperate table with all 3 records. I need this to show my customers how many duplicates they have in their database. This also allows them to determine which record should be used or removed.

Thanks

Peter