Query based on String value in list

[access_viper]

Hello again.

I have a drop-down list that contains string values. Is it possible to construct a query that will sum the total number of times that the string value is selected? For example,

String Value Sum
================
Chicken 3
Beef 9
Pork 2


I have been trying to work on this for a while and cannot figure it out. Can someone shed some light on this issue? Thanks.

 

[pbaldy]

Try

SELECT String, Count(String) AS HowMany
FROM TableName
GROUP BY String