>I have a print file which is created by selecting addresses from multiple database files. Thereby, the same names may be selected
>
>Is there a simple way to command to filter the file for unique names?
>I know I can sort and then compare records but was wondering if there is an easier way.
>
>Thanks
>
>Todd
You can run a select statement that will return records with duplicate values:
SELECT COUNT(*), * FROM SomeTable GROUP BY KeyField1, KeyField2 HAVING COUNT(*) > 1
the fields in the GROUP BY are what determines uniqueness.
Erik Moore
Clientelligence