Format Data from a table

[waq963]

Hi, I have a table that stores the following fields. Q No, Question, Category, Student and Score. I would like format like a table with Q No and Question on the left and Category and Student at the top. With the scores for the relevant fields. I have attached an example of what I need to be clearer. Thanks.

 

[ajetrumpet]

i don't know off the top of my head. but my guess would be that if you want this, you could easily do it with a BACK AND FORTH from excel for the manip. and then a transfer back as an import to access again. looking at the word doc. i can't get it. maybe someone else can...

 

[WIS]

Hi, I have a table that stores the following fields. Q No, Question, Category, Student and Score. I would like format like a table with Q No and Question on the left and Category and Student at the top. With the scores for the relevant fields. I have attached an example of what I need to be clearer. Thanks.

Set up a continuous form and use the Format -> Text Align for each of the Controls.

 

[waq963]

I am using access 2007, how do I get to the continuous form function. Thanks