Report layout - how do I print 10 classes on one 11x17 landscape sheet of paper?

[creolejazz]

Hi. Here's a report layout challenge for you.

I have ten kindergarten classes each in a different room with different teachers. Each classroom contains from 10-15 students.

My table has fields for grade (they're all kindergarten), classroom, teacher, and students.

I need to print all ten classrooms on ONE 11x17" sheet of paper, landscape orientation. Here's a graphic of what it should look like:

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

I have been unable to figure out how to set up this report to print properly. Any help appreciated. Thanks.

 

[WayneRyan]

CJ,

This might help:

http://www.access-programmers.co.uk/forums/search.php?searchid=2085916

Wayne

 

[creolejazz]

That didn't really help. Apparently the link doesn't work.

I've been working on this particular challenge for some months and can't get all ten on one sheet. Any help appreciated.