Use a report in Access rather than mailmerge to word. With the grouping
capability that is available to you in an Access report, it is by far the
easiest way to do this.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"Contro" wrote in message
ups.com...
Hi guys!
Basically, my problem (which I'm sure is a common one), is that I'm
trying to merge, from an access database query, fields to a single
document, but they come out on multiple documents.
I am basically trying to create a kind of examination report card for
students. There is a candidate form for their name, dob etc, and a
subform for their exam subjects and corresonponding grades. I want all
these grades and subjects to appear on each candidate's card, not a new
card for each candidate's subject and grade
Basically, this is what I want using fields name, dob, and subject and
grade (last two in subform)
Bobby Smith dob 19th July 1990
English Grade B
Spanish Grade D
but at the moment I'm getting:
Bobby Smith dob 19th July 1990
English Grade B
Bobby Smith dob 19th July 1990
Spanish Grade D
two documents instead of one.
Now I have had a look for possible solutions to this, and have found a
microsoft site
http://support.microsoft.com/?kbid=105888
which I do believe gives a solution to the problem, but I don't
understand it enough to change it to my context. This was found via
http://homepage.swissonline.ch/cindymeister
so if you could help me out by spelling it out a bit, that would be
great, as this would be such a great help!
Thank you very much in advance!
Contro.