>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
Try this:
SELECT * FROM TableName ;
WHERE Name IN (SELECT Name FROM TableName GROUP BY Name HAVING COUNT(*) > ) ;
INTO TABLE Duplicates
Chris McCandless
Red Sky Software