One Letter Per Person

  • Thread starter Thread starter Jessica
  • Start date Start date
J

Jessica

I have a table on course information which lists info on
courses (such as meeting venue and time) and another
table on personnel data (such as addresses). Each term I
need to mail letters to individuals listing in the letter
all the courses that they are going to teach. My problem
is that I always have multiple identical letters for
teachers who are teaching more than one course. Hence I
have to go through the letters and print the letter one
by one so that I am not printing duplicate letters and
waste letterhead paper.

Advice to solve my problem is really appreciated.
 
What if you made a subreport based on the course
information and had your main report based on the
personnel. Join the main report to subreport based on
whatever you use to determine who teaches which course.
Then, you should get the teacher listed, and all the
course information for that teacher.
 
Back
Top