Titles/Headings across Columns

[Ray]

I'm beginning to set up a school class list and need some suggestions
as to how to begin.. MS-Access 2007

It's a list of students - Grouped by Teacher - Grouped by Grade.
We're looking to have 3 columns of students on a page...

General Layout.....


F I R S T G R A D E
---------------------------------------------------------
Teacher 1 Teacher 2 Teacher 3

Student A Student D Student G
Student B Student E Student H
Student C Student F Student I



S E C O N D G R A D E
---------------------------------------------------------
Teacher 4 Teacher 5 Teacher 6

Student J Student M Student P
Student K Student N Student Q
Student L Student O Student R



Any direction will be valuable....
Thanks in Advance
Ray

 

[Golfinray]

The titles are movable. When you click on them, a tiny black bos will pop up

 

[Ray]

Sorry - I did a bad job explaining that -
What I'm having a problem with is getting the "Grade" text formatted.
I need the first group (Grade) to span the other 3 columns as I have
shown in the mock-up below.

Thanks...
Ray

 

[Duane Hookom]

I would use just the unique grades in the Main Report and create a "roster"
subreport or two for the detail section.