Sorting by field in a report

[Guest]

The following access query pulls in all appropriate data to make progress
reports for a high school:

SID (Student ID number/online grade retrieval password)
Full Name (Student name formatted "Smith, John (9)" )
Grade (Grade level, 9-12)
Password (Password student can use to retrieve grade online)
CC (Course number)
FullGrade (Grade formatted "78.2 C+")
Instructor (Teacher name)
Period (Period, 1-7)
CourseName (course name, ie, "Term 1: 7-English IV")
Comments (Teacher comments about individual student)

The form's header lists Full Name; the footer, SID and Password, and the
detail is one line per course that student has, each line listing Period,
CourseName, Instructor, FullGrade, and Comments.

As it stands now, the form is sorted first by Grade, then alpha by Full Name.

What I'd like to do is sort by fourth period teacher. I have a query that
pulls from the progress reports query every row where Period=4, sorting by
Instructor, Full Name.

Is there a way to get the student sort order from THIS query and print their
progress reports in said order? This would let us print them sorted by fourth
period teacher and thus distribute progress reports during fourh period.
Right now, we have to call a special homeroom class, where the students meet
in alpha-sorted groups!

Thanks!

 

[Douglas J. Steele]

In reports, sorting is controlled strictly by the Sorting and Grouping
dialog, not by the sort order of the underlying query.

I'm not sure you've given us enough information to help you write the query
that's required, but assuming a properly normalized database, yes, it should
be possible to do what you want.

 

[Guest]

You need to create a sort order in the report itself. To do this open your
report in design view thaen click on View>Sorting and grouping and follow the
prompts