Group Counts

  • Thread starter Thread starter Amy
  • Start date Start date
A

Amy

I have a drop down box where there are about five
options. I want to then do a count for each option. Can
this be done?

Thks, Amy
 
I have a drop down box where there are about five
options. I want to then do a count for each option. Can
this be done?

Thks, Amy
Click to expand...

Tables do not contain "drop down boxes". They contain fields of data;
a combo box *is a tool* to enter and manage that data! If this drop
down box is in your Table, please read

http://www.mvps.access/lookupfields.htm

for a critique of this Microsoft "misfeature".

But... to answer your question... create a Query based on this table,
joined to the Lookup table (you can't count on the lookup wizard to
help here!). Select the joining field from your table, and the option
text from the lookup table.

Change the query to a Totals query by clicking the Greek Sigma icon
(like a sideways W). Leave the default Group By on the option text,
and change it to Count for the linking field in your table. Open the
query and you'll have your counts.
 
Back
Top