A
Ann
I am using Access 2002. I have a query with one field called
txtUsedKnowledge that has four possible responses. They are Never, Small
Extent, Moderate Extent and Great Extent.
I did many calculations with these including counting them individually and
getting the percent for each one based on the over all count. Now I would
like to create a bar chart with the four responses listed that will update
each time it's run.
I created the chart but have to type in the figures for each response
myself. Since the calculations are done on the report and not in the query
is there a way to use the fields from the report. Unfortunately, this is my
first time trying to use the Chart feature in Access. If I can't do this
with the Chart option is there another way to have a bar appear on a report?
Thank you in advance for any help that will be offered.
txtUsedKnowledge that has four possible responses. They are Never, Small
Extent, Moderate Extent and Great Extent.
I did many calculations with these including counting them individually and
getting the percent for each one based on the over all count. Now I would
like to create a bar chart with the four responses listed that will update
each time it's run.
I created the chart but have to type in the figures for each response
myself. Since the calculations are done on the report and not in the query
is there a way to use the fields from the report. Unfortunately, this is my
first time trying to use the Chart feature in Access. If I can't do this
with the Chart option is there another way to have a bar appear on a report?
Thank you in advance for any help that will be offered.