Names query

[Rowan]

--
Rowan

I have a table with 50 peoples names in some of the names appear more than
once.

How do a make a query to extract any name that appears more than once.

Thanks

 

[Duane Hookom]

SELECT FieldName, Count(*) as NumOf
FROM tblA
GROUP BY FieldName
HAVING Count(*) >1;