creating charts from queries

[smcalles]

I'm using Access 2003 and am intermediate user but not a programmer.

I've created a database to track survey results to approximately 20
questions, each of which offers 5 possible choices for answers, and all of
which are stored in one table. I need to produce both totals and percentages
for each of the answers as they relate to 3 specific criteria, X, Y and
(X+Y). I have created queries that will retrieve raw numbers for one set of
questions, for which I'd then planned to use another to set of queries to
calculate percentages, and then create a chart to insert into the report.The
report will ultimately have approx 60 charts - 3 pie charts for each
question, each pie chart indicating totals & percentages of the given
answers. But charts apparently can only use data from a single query or
table.

I know about, but have never run, Union queries and have considered
make-table queries as an option, but haven't worked out the specifics. In
any case, both appear labor-intensive. If I'm on the right track, hurrah (!)
and I'll keep plugging along, but I do wonder whether there's an easier way
to go about this.

Sonia

 

[Duane Hookom]

You might want to download and review "At Your Survey" which can be found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. There is
a statistical report that includes pie charts of each question.

 

[smcalles]

Duane,

thank you again for your help. I downloaded AYS2000 and have a couple more
questions. In rptStatisticsWithGraphs, I couldn't find the control sources
"Responses" or Number of Responses." This is of particular interest to me
because I have what appears to be the opposite problem: my report returns
the evil Name? error even though the control sources (queries) are all
intact and work independent of the report, i.e., when I run the queries, I
get the info I seek.

Sonia

 

[Duane Hookom]

I create a temporary table for the report (ttblSurveyResponses).

 

[smcalles]

So, why am I getting the "Name?" error on my report?

Online troubleshooting has these resolutions to the problem:

a.. Make sure that the field specified in the control's ControlSource
property hasn't been removed from the underlying table or record source
The fields have not been removed - they exist in queries.
a.. Check the spelling of the field name in the control's ControlSource
property.
Checked.
a.. If you specified an expression in the control's ControlSource
property, make sure that there is an equal sign preceding the expression.
Ditto.

What am I doing wrong?

Sonia

 

[Duane Hookom]

Open the report in design view and find the control source of the text box
that displays Name?. Then check the report's record source for that
particular field.