Parent/Child bulletted merge fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CCousins - 20 Jun 2006 18:00 GMT

The purpose of the document is to serve as a survey report, where the survey
was collected in Access 2003 and the report will be developed in Word 2000.

The problem: From queries with two fields, Town and Comment, how can I set
up the Town field to be a parent to a list of bulletted comment fields? As:

Town1
*Comment1
*Comment2
Town2
*Comment1
*Comment2
*Comment3
....etc.

I've searched the group, but I may be unaware of the right key words for
this problem.

Thank you in advance for your help!

Reply to this Message

Doug Robbins - Word MVP - 20 Jun 2006 19:09 GMT

You should use a report in Access. It is far easier and more capable than
Word for this type of thing.

However, if you are a masochist, see the "Group Multiple items for a single
condition" item on fellow MVP Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

and at

http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm

Signature

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

> The purpose of the document is to serve as a survey report, where the
> survey
[quoted text clipped - 18 lines]
>
> Thank you in advance for your help!

Reply to this Message

CCousins - 20 Jun 2006 19:39 GMT

Thanks, Doug. And, yes, I do believe I may be a secret masochist. The
requirements of survey reporting, such as explanations of method and
statistical development--not to mention heavy-duty text selection and
manipulation on a survey with multiple comment fields--couples with my
abysmal knowledge of Access reporting to push me in the direction of
self-flagellation. If I had a spare week, I'd probably invest in a course in
Crystal Reports. Besides, the printing outfit I use is still using a couple
dozen monks with quill pens to copy and illuminate my text submissions.
Anything beyond a Word file may be lost on them.

> You should use a report in Access. It is far easier and more capable than
> Word for this type of thing.
[quoted text clipped - 34 lines]
> >
> > Thank you in advance for your help!

Reply to this Message