467,875 Members | 1,418 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,875 developers. It's quick & easy.

Multiple columns and rows for each record?

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.
Aug 21 '07 #1
  • viewed: 1665
Share:
7 Replies
Rabbit
Expert Mod 8TB
How are the tables set up?
And what are these CH###### strings?
Aug 21 '07 #2
Let's try this again. Didn't realize that it smooshed everything when I submitted.

The CH CL is just the class number. Just text.

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:

Expand|Select|Wrap|Line Numbers
  1. Instructor
  2.  
  3.                      Punctual Knowledgeable Respectful
  4.  
  5. Bio1                   3.4             3.7            2.8
  6. CH393094
  7.  
  8. Chem1
  9. CL349750            2.4            3.8             3.7
  10.  
  11. My boss is wanting it to look like this:
  12.  
  13. Instructor
  14.                                Bio1          Chem1
  15.                            CH089084     CH90750
  16.  
  17. Punctual                     3.4           3.2
  18.  
  19. Knowledge                  2.8            3.7
  20.  
  21. Respectful                  3.8            2.8
  22.  
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.
Aug 21 '07 #3
How are the tables set up?
And what are these CH###### strings?
The table contains the instructor name, course number, course name and the score received by each instructor in several different categories.
Aug 21 '07 #4
Rabbit
Expert Mod 8TB
Your tables aren't set up for that kind of display. Off the top of my head, and using your example, you'll need upwards of 5 queries and 1 extra table.

I don't know why they want to view it the way they do, I feel your way would be better. If they still want it that way we can help but I'd rather not go through the hassle if they can be made to see reason.
Aug 21 '07 #5
Scott Price
Expert 1GB
My boss is wanting it to look like this:
Let me guess... Your boss has pointy hair? You don't happen to work in a large corporation, do you? LOL

Too bad Dilbert doesn't have a theme song, or I'd be humming it to you :-)

Regards,
Scott

p.s the way you have it is far more understandable to my way of thinking... I agree completely with Rabbit on this one.
Aug 21 '07 #6
The reason that the report has to be set up this way is that there is one instructor per page and each instructor teaches around 3 classes. With her way the three would go across the top and the 17 variables would go down the page. This keeps us from having to work in landscape view.

Someone at lunch mentioned a cross tab query?
Aug 21 '07 #7
Rabbit
Expert Mod 8TB
The reason that the report has to be set up this way is that there is one instructor per page and each instructor teaches around 3 classes. With her way the three would go across the top and the 17 variables would go down the page. This keeps us from having to work in landscape view.

Someone at lunch mentioned a cross tab query?
Crosstab yes. But only after you restructure the tables.

So when I was saying 5 queries and 1 extra table, with this new information it'll be 19 queries with 1 extra table. The last query being a crosstab. 17 of the queries will be pretty much identical with the exception of which column it uses. Let me know if you want to continue.

Also. You might be able to pull it off with some tricky reporting stuff. Set all the controls and labels to display vertically and set the page view to landscape. And toss in a page break at the bottom of the detail section. This is also going off the top of my head but more so than the other idea.
Aug 21 '07 #8

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by simchajoy2000 | last post: by
7 posts views Thread by samoore33 | last post: by
7 posts views Thread by =?Utf-8?B?TG9zdEluTUQ=?= | last post: by
reply views Thread by jack112 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.