Query to summarize evaluation results

  • Thread starter Thread starter HLCruz via AccessMonster.com
  • Start date Start date
H

HLCruz via AccessMonster.com

I've tried to search out this answer in previous posts, but couldn't seem to
find anything that fit. My apologies if I missed something out there...

I have a table of evaluation results; there is an auto-number pkey for each
evaluation and a slew of fields to represent each evaluation question named 1,
2, etc. Most of the questions are a yes/no type, however I have several
questions that store a combo box selection. The combo box is based on a
table with ResponseKey (auto number) & ResponseType (text) as fields. There
are a total of 5 responses such as Agree, Disagree, etc. I would like to
produce a report that will show the percentage of responses for each type - i.
e. for question 6, 28% responded as Agree, 10% as Disagree, etc.

I have "thought" up as a way to do this in my query by creating 5 calculation
fields for each question and then a totals query to summarize. This seems
like the long way to do things ... is there a better way?

Thanks in advance for anyone who has some advice!

Heather
 
Unfortunately the better way involves a redesign of your table structure.

You really should have started with a mininum of the following tables:

Evaluation - Information identifying one evaluation
Questions - List of questions
Responses - Responses received to the question - one record that has the
evaluation number, the question number, and the response

If you had that minimal structure, then your query would be fairly simple.
WIth what you apparently have there is no really simple way to get the data
out.

Duane Hookom has a sample survey database at

http://rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

This fully functional application uses a small collection of tables,
queries, forms, reports, and code to manage multiple surveys. Users can
create a survey, define questions, enter pre-defined answers, limit to list,
report results, create crosstabs, and other features without changing the
design of any objects.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top