Hi Steven,

You could try:

SELECT myfield, COUNT(*) ;
   FROM mytable ;
   GROUP BY myfield ;
   HAVING COUNT(*) > 1 ;
   INTO TABLE mydupes

This will give you a Table of Duplicate values is myfield and the number of occurences.

Hope this helps,
Gavin...

>How can I scan a table and find duplicate values in a particular field? I want to create a primary index on two fields and it tells me it can't be done because of dups.