Hi James,
The simplest way to do this is to revise your query so it returns one
record per doctor, with the patient information concatenated into a
single field (with a paragraph mark between each patient and a tab
between each item of information on the patient).
The fConcat() function at
http://www.mvps.org/access/modules/mdl0008.htm
can help do this. You'll need to replace the "; " separator it uses with
vbCR or vbCRLF.
(If you want the patient information to go in a table in the Word
document, create one field in your query for each column in the table,
and use fConcat() on individual fields).
For more flexibility it's necessary to use write VBA code that controls
the creation of a Word document and puts the data exactly where it's
needed.
The other approach is to do it all with an Access report. You lose
Word's finer typographic control but sorting, grouping and sub-reports
are easy.
