Totaling items in combo box

[C Burch]

I have a combo box in one of my tables that gives 10 possible choices. I'd like to do a query that groups this field and counts or totals each item.

Such as first in list then =

then next on combo list then =

I'd like it to count these items for me, I've been counting them by hand for months, I can't seem to get the criteria expression right. I'd appreciate any help at all!

 

[arickards]

Use a crosstab query to accomplish this. Use the GroupBy and Sum features.