Need help laying out report with "columns" of data

[creolejazz]

Hi. I'm looking for help on how to lay out a report containing data about classes at a school. I need it to look something like this:

http://www.south-haven.org/classroomexample

I've got a table containing these fields:

- Grade (there are seven grades -- Kindergarten, 1st, 2nd, 3rd, 4th, 5th, & 6th)
- Classroom # (there are ten classrooms for each grade)
- Teacher (there are two teachers in each classroom)
- Student (there are ten students in each classroom)

I need to print a seven-page report on 11x17" paper, landscape orientation. The first page should show all ten Kindergarten classes, their classroom #s, their teachers, and their students in ten "columns". The second page would show all the 1st grade data in ten columns. The third page would have all ten 2nd grade classroom data in columns, etc.

I would like each page to display ten (one for each class in that grade) columns, each column showing:

Grade, then under that...
Classroom #, then under that...
The two teachers in that room, then under that...
The ten students in that room.

...so that there are ten short columns displaying the data for the ten classes in that grade. On the first page, the tops of all ten "columns" would read, "Kindergarten". The tops of all ten on the second page would read, "1st grade", etc.

Ideally, there would be five classes on a top row of the page and the other five directly under them forming a second row of classes.

I am using Access 2007 and have gotten pretty good at queries, reports, etc. but I need some help setting up this report in the this format. I've attached a pdf of what (roughly) the first page should look like or you can just click the link above.

Can anyone tell me how to go about laying out my report so that it looks similar to this? Any help appreciated. Thanks.

 

[creolejazz]

Sorry, my original pdf file example was incorrectly formatted. I have updated the corrected file to accurately show the example.