Multiple fields on one report line

[swilliams2785]

I can't believe my problem is as difficult to solve as my web search efforts indicate. In a nutshell I have the following data:

Record# Period Subject Grade
1 1 Math 90
2 2 Math 80
3 3 Math 85
4 4 Math 95


I want the report to show:

Subject Period 1 Period 2 Period 3 Period 4
Math 90 80 85 95


I’m OK with the formatting I just can’t get the grades to print out on one line. This is a simple representation of a complex report card that reports 99 items each grade period so a single record with all 99 grades for 4 report periods isn’t possible.

I can't format the examples above correctly in this test window so I have attached a Word document that displays the data in the correct format.

 

[Galaxiom]

Use a CrossTab query.

 

[rana1978]

Hi,

Attached DB can help you.

Rana

 

[gemma-the-husky]

but the basic reason this isnt trivial, is because access doesnt realy work like this - and in theory there could be an unlimited number of rows -

what happens if you have 20 quarters?

what happens if you want to test quarters 1 to 4 sometimes, or quarters 5 to 8 other times?

what does your report look like if a page width is exceeded?

 

[swilliams2785]

Thank you Rana. This is what I needed.

Steve

 

[rana1978]

Dear Friend (gemma-the-husky)
Actually I am also new in Access and whatever I’ve learnt, it’s only from various Posts of this forum.
I have the same question like yours.
What should be done if the number of row is unlimited?
And how can we filter the rows for particular report?
How can we update the report format automatically if any new row (new column name for CrossTab query) is added?
If you or other friends have any suggestion, please educate me.
Regards
Rana