Need help with running a count 1

[TNDaffy]

need to run a report with a count by county
for example in my table I have a county field, so in my report I need to list each one of those county's and how many entries there are for each one. How can I get it to pull a total for each county individually?

 

[link9]

SELECT count(county) as countyCount, county FROM tableName GROUP BY county

results would look like:
countyCount county

5            gwinnett
6            fulton
7            dekalb
10           forsyth

You could add any WHERE or ORDER BY that you needed as well -- ORDER BY goes after GROUP BY and WHERE goes before.

Let me know if that works for ya
Paul Prewett

 

[TNDaffy]

ok I'm not quite with you, let me tell you this, the name of the field is Day Camp, and I'm splitting it there's 18 possible entries in that field and I want them counted seperately, to put in my report?