Report expressions and functions

[Guest]

Ok, my table contains information gathered from a "customer satisfaction
survey" Most of the fields represent questions that have a drop down with
"yes", "no" - AND "n/a" - and some are blank [they are not "yes/no" format,
because I need "n/a" also]. On the report, how do I calculate the % of the
total answers that are yes, no and blank/n/a

 

[Duane Hookom]

The best method is to work with normalized tables like those in At Your
Survey found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

If you can't normalize your table structure, you can accomplish something
similar with a union query:

SELECT "A" as Question, [FieldA] as Answer
FROM tblCustSatisSurveyName
UNION ALL
SELECT "B", [FieldB]
FROM tblCustSatisSurveyName
UNION ALL
SELECT "C", [FieldC]
FROM tblCustSatisSurveyName
UNION ALL
' etc
FROM tblCustSatisSurveyName;

You can then create a totals query based on your union query that groups by
Question and Answer while counting Answer.