<font face='Verdana'>I am a ColdFusion developer and I have a form that contains about 100 checkbox items. A user selects multiple items, submits it, and each item is inserted into it's "own row" in an MS Access database. The database consists of only 2 columns: ID and Checklist. I need a SQL statement that will count each "instance" of the checklist item. For instance, the following entries are in the database:

ID Checklist
1 Yellow
2 Blue
3 Green
4 Yellow
5 Yellow
6 Green

How do count how many times each item in the "Checklist" column is listed in the database?</font id='Verdana'>

select count(tablename.fieldname) from tablename inner join tablename2 on tablename.fieldname = tablename2.fieldname

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
select count(tablename.fieldname) from tablename inner join tablename2 on tablename.fieldname = tablename2.fieldname

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Thanks, but that's not going to work. There's only one table so there's nothing to join.

select Checklist, count(ID) as NumOcurrence from tablename group by Checklist

let me know if it works.

I've already found a solution to the problem

Wats the solution??