I only have one column, that's the problem. I can do three columns but then I'd have to do a lot of extra coding. And if I used your formula, I'd have to change the report everytime a new value was entered for the textbox :/...

I did a search but couldn't find a question similar to mine. I need to count the values in a textbox on a report and have the count subtotal in a group footer. But I need three different counts on the same textbox because there are three possible values and I need a count on each. I can't just do a simple DCount on the table and manually define the criteria because there are many different groups that will need the counts for only that group....