[RESOLVED] How do I get all names that appear more than 3 times?

[Arc]

Hey guys.

I have a database table that looks like

JobID | Name | etc...

I am trying to make a list of all the names that appear more than 3 times.

For instance, if I have this row of data

1 | Joe
2 | Jim
3 | Joe
4 | Jim
5 | Joe
6 | Jim
7 | gregg
8 | bob
9 | billy
10 | Joe

The result would return only "Joe" and "Jim". Is this possible?

Thanks.

[Shrike]

Have a look at GROUP BY and HAVING.

[Arc]

Thanks, I think that worked. It seems to so far anyway.

"SELECT Name, COUNT(Name) AS TheTotal FROM tblJobs GROUP BY Name"