Access Report for Dance classes.
One page per student listing their classes.
Grouped by Name then sorted by Class, Date, and Time.
There are 380 pages printed alphabetically by Name.
The whole report then must be hand-sorted by header information for
handing out.

Report information:

Page Header has info for the first class of this student.
(e.g. JANE DOE MONDAY 5:45PM JAZZ [teacher]
Class#)

Report body has information for classes taken by student.
(e.g. JANE DOE JAZZ [info]
BALLET [info]
MODERN [info]
TAP [info])

Is there a way to print by the header information? This facilitates
handing out.
We have changed grouping and sorting in both/each the Query and the
Report
- but it messes up the report infor,ation order!

On Jan 23, 5:53*pm, Deac <mwal... (AT) centurylink (DOT) net> wrote:
In a case like this I'd take the cheap way out. Let's say your key is
StudentID. I might create an unbound text box, allow it to grow, and
call it StudentHeader, and under the Data tab in ControlSource enter:
=RptHeader([StudentID])

Then I'd write a function in a Module called RptHeader that grabs the
studentID, searches the requisite tables, and process the calculations
to create a header for that student.