473,320 Members | 1,936 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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
7 1831
Rabbit
12,516 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
12,516 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
1,384 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
12,516 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

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

Similar topics

4
by: Gleep | last post by:
Hey Guys, I've got a table called Outcomes. With 3 columns and 15 rows 1st col 2nd col 3rdcol outcome date price There are 15 rows...
5
by: jason | last post by:
I could sure use some conceptualization and query help with a Page Watch System I am building in Access 2000 and Asp. I need to cycle through databae and generate a compiliation query email that...
8
by: Sans Spam | last post by:
Greetings! I have a table that contains all of the function permissions within a given application. These functions are different sections of a site and each has its own permissions (READ, WRITE,...
6
by: Steven An | last post by:
Howdy, I need to write an update query with multiple aggregate functions. Here is an example: UPDATE t SET t.a = ( select avg(f.q) from dbo.foo f where f.p = t.y ), t.b = ( select sum(f.q)...
2
by: Will | last post by:
I have a table, tblManinstructions with fields Code & InstructionID, one Code can have many InstructionID. I also have tblinstructions (fields instructionID & instruction). What I want to do is...
1
by: Andrew | last post by:
Hey all, I am very new to ASP.Net (and .Net in general), but that isn't stopping the boss from wanting to begin new projects in it. This latest project has me kinda stumped and after a couple...
3
by: simchajoy2000 | last post by:
Hi, I am trying to use a VB.NET listview object to display information from a datatable. I need to have two columns of information but I don't want the user to be able to select each column...
7
by: samoore33 | last post by:
I want to list all of the items in a dataset in a textbox. The dataset has multiple tables. When I try to use the code below, even though I dim myState as the DataTable("state"). It still looks for...
52
by: MP | last post by:
Hi trying to begin to learn database using vb6, ado/adox, mdb format, sql (not using access...just mdb format via ado) i need to group the values of multiple fields - get their possible...
7
by: =?Utf-8?B?TG9zdEluTUQ=?= | last post by:
Hi All :) I'm converting VB6 using True DBGrid Pro 8.0 to VB2005 using DataGridView. True DBGrid has a MultipleLines property that controls whether individual records span multiple lines. Is...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.