Mail Merge Query - Help!

[RichardMc]

I need to create a mail merge from an Access 2k DB to a Word 2K doc.

The Access DB contains 3 tables:
Attendee - name, address of people who attended courses
Sessions - the details of the courses, including no. of continuing education credits for each course
Signups - attendee Id and Id of courses they attended

I have created a simple query that returns attendee info with details of courses they attended and the number of credits per course. Since most attendees went to more than one course, when I merge to word I end up with one letter for each course for each attendee.

I need ONE letter for each attendee that shows All the courses they went to and the credits they received for each course, and would also like to total those credits per attendee.

Any ideas on how best to achieve this?

All input greatly appreciated!
Thanks, Richard

 

[Rich]

Why not just create the Report in Access ?

 

[RichardMc]

A report did turn out to be the easiest solution. Thanks!

 

[database]

A report did turn out to be the easiest solution. Thanks!

Hey Richard,

I have a similar problem... Can you tell me the solution to this problem?

Thanks,
db

 

[info_seeker]

Will a crosstab query work?

 

[RichardMc]

I'm not sure about a crosstab query, but a report worked great, grouped on the unique ID field so that only 1 report page output per unique ID