By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,519 Members | 2,332 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,519 IT Pros & Developers. It's quick & easy.

Count total number of each option for a report

P: 1
I have a table with one field a combo box with about 10 different options- (text from another table) for a client information table

I want to make a report that gives me the actual number of each option
I have a query and report that shows me the client ID and what option was selected
But on the report i want a total of how many client selected each option ie

option_one 10 client selected this
option_two 25 clients selected this

any assistance is greatfully appreciated as I am just a learner here
Aug 10 '12 #1

✓ answered by Rabbit

Use a aggregate query and group by the options.

Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,366
Use a aggregate query and group by the options.
Aug 10 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.