Need Help With Sort

[adario]

I have a form letter going out to instructors. In the letter each instructor is given the names of students working for him/her each semester, the courses each student is working, and the hours they are allowed to work, given their pay-grade.

The form letter is sorted by instructors and semester. In the body of the letter there is a spot giving student info.

I tried doing this letter using sub-summary by "instructor", but that doesn't seem to work correctly. Please help

tks

Amy

[mr_vodka]

Can you elaborate on your table structure and fields?

[Lee Smith]

Take a look at this example, and see if it is what you want. Link

also, go to databasepros.com, and do a search for Letters, there are several files, and articles about how to do these. The link is above, just below the URL for the page, [color:blue](Examples) DatabasePros.com

HTH

Lee

[adario]

Hi Lee,

I've got 2 tables

1. table of COURSES

2. table of GRADERS

3. table of STUDENTS

Course Table: fields include CourseID#, SectionID, TermID, SlotID, Instructor, and RecordID (combination of the CourseID#, SectionID, TermID)

Grader Table: StudentID#, First Name, Last Name, Paygrade, Record#

Student Table: StudentID, First Name, and Last Name

The GRADER TABLE is my main table. The StudentID connects it to the Student Table and the RecordID connects it to the Course Table.

I've selected the records (for the form letter) by Semester & Term (academic year) and get all the students working for the upcoming term. Than sorted the records by Instructor, so that an instructor will receive 1 letter with all his/her students listed on it.

Thank you

Amy

[adario]

Hi Lee,

Thanks for the information, but I think it's a bit different than my problem. It's a really great thing though!

Thanks much

amy

[mr_vodka]

Perhaps this can get you started.

PrintLetter.zip