De-Dupe Query

[benwo]

Hi

I have a set of data in a table that is full of dupes, anyone know a simple De-Dupe Query? Ideally by phone number

Thanks

Ben

 

[Smart]

Try this

SELECT Yourtable.phoneno, Count(Yourtable.phoneno) AS CountOfphoneno
FROM Yourtable
GROUP BY Yourtable.phoneno
HAVING (((Count(Yourtable.phoneno))>1));