>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
Thanks a lot for your help Stephan.
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould