group by category

[Susan]

I am trying to create a mail merge document using
the "category" type document in Word 2000. I need to
have most of the data come from one table (company info)
but I need to have several lists print for each company
and I can only get the first record to print.

Example: a list of buildings on the property where the
paragraph reads "...the following structures are present
on this property:" and I want the list of items to print
here. There could be as few as one and up to as many as
are in the database(unlimited). They are currently
stored in an Access database with the company info in one
table and the buildings in a related table
where "CompanyID" is the field that links them with a one
to many relationship.

To complicate the problem, several pages further in the
document I need to use the same process to list "Tanks"
on the property (from another related table), then after
that I need to list "People Interviewed" (from yet
another related table).

I've tried the KB #211303 article, but can't make it show
more than the first record in the related table. Can
anyone point me in the right direction??

I thought about running this as separate Access reports
from a macro. I can make it print all the info this way,
but I need to end up with one final Word document instead
of, say, four separate ones that would have to be
manually combined.

Thanks in advance for any advice!

 

[Doug Robbins - Word MVP]

Hi Susan,

I would do it completely Access. Word does not really have the ability to
do it. You might take a look at the "Multiple items per condition" item
under the "Special merges" section of fellow MVP CIndy Meister's website at

http://homepage.swissonline.ch/cindymeister/MergFram.htm

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP