Hi, I was wondering if I could do a "Control Break" Report from Excel.

I'm working in a school with students. Each Student is in a seperate
grade_level and they are taking classes, for which they get grades.

Thus I've got a spreadsheet with the following grades already sorted.

Name    GradeLevel    Class    Grade

The Name Field has the student's Name in it. For instance Barry Jones
The Grade Level has the student's gradelevel. For instance: 10th or 11th
grade.
The Class has the Course name that the student is taking such as: English II
The Grade has the Grade the student gets for the class such as a B, or C, or
A

The data is already sorted by Gradelevel and then by Name and then by Class.

What I want to do is print out report cards on each student. In order to do
that I need the report to do a Control Break when the student name changes.
It needs to forward to the next page and print out a new page. Thus there
will be one page per student.

What I envision is something like this:

Name: Barry Jones                    Grade Level: 10th

Courses                                    Grade
Logic                                        88
Algebra II                                 98
English II                                  79
Drama                                      94
Latin II                                      82
Life Management Skills              91

Then I want it do a pagebreak and then do the next student.

My first question is whether this is possible.

My second question is what is the best way to do this? I looked a little at
Pivot reports, but it didn't seem to give me what I was looking for.

Should I import all of the data into Access and create are report like that?

Thank you so much!

Kees