Word Mail Merge - Multiple records per merge 1

[DawsonUK]

Hi,

I'm currently developing a Database to hold details of students for a University in Aberdeen, Scotland. The problem I'm having is regarding mail merge, having only ever played around with it before.

Put simply, I have a query that picks out records that are to be merged. This query lists students, modules and assignment submissions. One student can have many modules, of which, each can have many assignment submissions.

When I come to mail merge this query, the outcome is about 8 letters to each student on average, taking a new page for each assignment submission.

What I'd like to do is to create the document, with the students name/address etc at the top, the followed by a list of modules, each broken down (say indented in a bit) with the assignment submissions for each of those modules, and the grade for it.

I'd appreciate any information or help regarding this, as Microsofts Help is useless, and I can't find anything using the search facility, as I'm not sure what the problem would be called!

I'm Access and Word 97 if this is of any help, and I can post more details if needed, for example, attribute names etc.

Thanks in advance, any help would be greatly appreciated

David Dawson

 

[MoiraT]

The mail merge is trying to create a record for each student/module. Your best bet is to do this as a report in Access, as the mail merge facility doesn't allow you to have multiple levels of records, which is what I think you have here. If you do a report in Access you can have the student's name and address as a group header always starting on a new page, and the modules in the detail section.

 

[DawsonUK]

Hi, I gave up on the word approach for this, an access report is nice and simple, but just lacks to ability to let users edit the layout, in my case anyway. 26 users will have access to the database, none of which will be allowed to edit any reports, so word documents stored locally on their machines would have been ideal.

Thanks for replying though, and have a star for your help

David