>SELECT DISTINCT * FROM ACCOUNTS gives me the non dup records from my accounts table. How do I get the dups using the same command? Is there something like SELECT NOT DISTINCT * FROM ACCOUNTS?
>
>Any suggestions or comments will be welcome, thank you.

This is one sample SQL statement I'm using in a project and works fine.

Hugo

===========
SELECT DISTINCTROW First(CALLS.User_Name) AS [User_Name Field], Count(CALLS.User_Name) AS NumberOfDups
FROM CALLS
GROUP BY CALLS.User_Name
HAVING (((Count(CALLS.User_Name))>1));