I need a record count of individual categories from a list box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

msimons - 08 Apr 2008 22:24 GMT

I have created a list box with about 20 categories. I need to have a record
count of each category in my report. Please help. I have a total of all but I
need individual totals.

Thanks!

Reply to this Message

Jeff Boyce - 08 Apr 2008 23:10 GMT

Not sure how this is a "reports" question, since you're asking about a
listbox.

Have you tried using a Totals query? You could GroupBy category and Count
one of the other fields (like the ID).

Regards

Jeff Boyce
Microsoft Office/Access MVP

>I have created a list box with about 20 categories. I need to have a record
> count of each category in my report. Please help. I have a total of all
> but I
> need individual totals.
>
> Thanks!

Reply to this Message