I work at a college and have created a report that automatically retrieves the instructors name, class number, class name and the scores that instructor received on his evaluations. Right now the report is showing the questions of the evaluations on a row at the top with the numbers underneath, like this:
Instructor
Punctual Knowledgeable Respectful
Bio1 3.4 3.7 2.8
CH393094
Chem1
CL349750 2.4 3.8 3.7
My boss is wanting it to look like this:
Instructor
Bio1 Chem1
CH089084 CH90750
Punctual 3.4 3.2
Knowledge 2.8 3.7
Respectful 3.8 2.8
But no matter what I do I can't get it to change to that. Even though I've set up all the things to look like that I can't get it to work.
Any suggestions?
Oh yeah, I'm using Access 2003.