Access data to word mail merge

[Bruce Hawkins]

I need to write a letter that reports on a student and lists from 1 to 20
courses that they have completed. Normally in access the data would be in a
student table, a course table, and a connection table that connects students
to courses. A query then gives me several records which gives me one mail
merge letter for each course.

I can make this work by having a table with fields for course1, course 2 ...
to course20, but I would like to know if there is a better way. The
paragraph structure of the needed letter seems to hard to build as an Access
report since I need to use merge fields in the paragraph.
Any ideas?

Thanks for any help.
Bruce Hawkins

 

[Duane Hookom]

There are ways in Word to move to the next record on the same page. An
Access only method is to use the generic concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. You can
separate the courses with Chr(13) & Chr(10) as delimiters.