Names query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

--
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
 
SELECT FieldName, Count(*) as NumOf
FROM tblA
GROUP BY FieldName
HAVING Count(*) >1;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

name query 1
Total appointments per agent 2
Count text values in a Access Field 0
Counting days 5
select to compare 3
Need a query to get rid of duplicates using two tables 1
Members give more than once but need latest to send letter 1
List all records that appear more than once 1

Back
Top