Dear Luis,
I have found the following way very helpful to find duplicates.
SELECT CNT(*) AS nCount, * ;
FROM [Table] ;
ORDER BY [The fields you want to check for dupicates ie. nCustId,
cCustName,,,,] ;
HAVING nCount > 1
This will give you a query table displaying all duplicated records.
Stephan
stephan.nilsson@trenob.se
