Help summarizing

  • Thread starter Thread starter Christine
  • Start date Start date
C

Christine

I have 20 questions that get answered by checking a
response such as Good Average Poor...I have created
these, in my form and report,as both check boxes and
option groups (it can be either). What I am trying to do
is create a summary report that counts how many answered
Good, Average, Poor for each of the 20 question. That's
the first problem I cannot get around. Once that is
accomplished, on this same report I need it to tell me
out of those responses, how many were Management, Admin,
etc. (these are categories listed in the table as
checkboxes). I hope this makes sense because I am really
frustrated with this mess and would appreciate any help
you can give. Here's a visual of what I need:

Total Management Admin Clerical

1. Public Image
Good 3 1 2 0
Average 8 4 2 2
Poor 2 0 0 2

2. Personal Opinion................


Thank you in advance,
Christine
 
Finally figured out the summarizing problem. I used the
following to sum the responses:
=Sum(IIf([Category]="1",1,0)) (This is for good)
=Sum(IIf([Category]="2",1,0)) (This is for average)
etc.
Now what I need is to figure our is of the total # of
people who answered this one question what percent
answered good, average, etc. all total 100% for that one
question.
 
Back
Top