>Hello Hugo,
>Is there something missing in this code? I see a semi-colon at the end of the code. Can you re-send please? Thank you again.
>
>>>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));
Morys,
this works, it uses agregate functions to do so. What is does is select any record where the calls.user_name field is repeated more than once (for example, Administrator) and lists it with the number of times it shows up. It can also be used to checked on multiple fields for uniqueness.
Hugo
"My get up and go must've got up and went"
-Steve Tyler, Aerosmith