Jeff,
Thanks for you response. I gave a little more information in my second
response to steveM.. here is what I need
Here is my problem... a user fills out a form that has 25 questions and each
question has an option group (yes, no, na). Dumps the information into the
table.
I need a report where they choose the Site Lead and get a report that lists
each question down the left of the report, the Managers going across the top
(could be up to 10 managers) and underneath each manager the total number of
questions (answered yes or no) and also the percentages of yes's to the
total. The problem is that you can't run a report with the managers going
acros the top because you can't assign the column headings upfront because
depending on the Site Lead the Managers will change.
My thought was if they picked the managers from a list, I would be able to
run 10 individual reports and pull them together on one report based on each
manager they chose from the dropdown.
Sounds rediculous to do, but if you can think of a better way to do it i
would greatly appreciate the help.
Data Example:
Site Lead Manager Employee Q1 Q2 Q3 Q4 Q5 - Q25
Report Example:
Manager 1 Manager 2
Manager 3
Q1 Total Total Yes % Total Total Yes % Total Total
Yes %