Charts, reports and crosstab queries

[Guest]

Hi everyone,

OK, after many hours of frustratingly banging what’s left of my fried brain
against the blank wall of my inability to comprehend the mysteries of Access
charting, I still have enough with to call in the cavalry!

Here is the challenge. I have a crosstab query which collates count of
answers for a series of questions such as:
Question Yes No Not Sure
Blah1 1 10 3
Blah2 4 8 5

The character part of the report groups on each question to give the count
of answers and the percentages.

All I want (and am utterly unable to fathom in Access) is to have a chart
(Bars, or Pie) illustrating the set of answers for each question.

Can this be done? I am using Access 2002.
If yes, can anybody point me to a tutorial please?

Thank you I advance.

 

[Guest]

I think the issue might be your use of a crosstab. There is a sample "At Your
Survey" at http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane
which has a report with pie charts for each question.