Código SQL [-] select distinct campo FROM tabla WHERE campo In (SELECT campo FROM tabla As Tmp GROUP BY campo HAVING Count(*)>1)
select distinct campo FROM tabla WHERE campo In (SELECT campo FROM tabla As Tmp GROUP BY campo HAVING Count(*)>1)