November 19, 200817 yr 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
November 19, 200817 yr 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
November 19, 200817 yr Author 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
November 19, 200817 yr Author 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
Create an account or sign in to comment