Percentage

[Chi]

Hi

Would you please help me to calculate the percentage of each category, but
not the NOT ANSWER (in my case is 9) and the total of percentage for Strongly
Agree, Agree, Neutral, Disagree and Strongly Disagree equals to 100%?

I assume that people who didn't answer the question will choose AGREE
catalog.
Ex:

I my report I have following information.


Scale Evaluation Percentage
(I collected form customers)

5 Strongly Agree 2
4 Agree 1
3 Neutrol 2
2 Disagree 4
1 Strongly Disagree 1
0 Not Answer 9

Total = 11

Thank you
Chi

 

[Al Campagna]

Chi,
I think your example should have a total of 10, not 11 (after dropping
the 9).
Create a "bound" calculated field in your query...
Score : IIF(Scale > 0, Evaluation, 0)
Then in your group footer claculate the total...
= Sum(Score)
.... in this case would yield 10.

Scale should be in 2 fields
Scale Desc
5 "Strongly Agree"
4 "Agree"
etc...
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."