count occurances in an option group

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Would like to graph information from an option group, ie the number of occurances of each item in the group. It seems that you can only use the count function in a query one time, not multiple times to capture a count of each item in the option group
How is this done so that I may present a bar or pie chart on a form or report showing the relative number of each item
 
Dear Bruce:

An Option Group is a control on a form. Somehow, I don't think this
is what you're talking about.

Counting the "number of occurances of each item" requires that you
group the query by each item.

Please post the SQL of your current query, and explain just a bit
about what it does now, and what you were wanting.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
I have a three button option group. It generates a 1,2 or 3 in my table depending on which button was pushed on the form. I need to present summary data in the form of a pie chart that shows the number of each button selection over a period of time, ie 12 occurances of #1, 24 occurances of #2, 17 occurances of #3 in the previous month. How do I count the occurances of these three buttons? A count query for any one of the buttons (numbers) individually will return the correct count for that button. According to my experience and my Access 2002 Bible this is all I can do. There must be a way to perform this task or else what is the use of an option group? You would be better off creating a separtate field for each of the three choices in order to graph the data.
 
Dear Bruce:

In a "Totals Query" you need to Group By the column in your table that
contains 1, 2, or 3. Show that column as well.

If you would post the SQL as I asked, I might be able to see where you
are, and what the problem might be.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
The information graphed depends on the Row Source property of the control.
You should be able to use a group by query as the Row Source.

--
Duane Hookom
MS Access MVP


Bruce said:
Would like to graph information from an option group, ie the number of
Click to expand...
occurances of each item in the group. It seems that you can only use the
count function in a query one time, not multiple times to capture a count of
each item in the option group.
How is this done so that I may present a bar or pie chart on a form or
Click to expand...
report showing the relative number of each item?
 
Back
Top