conditional field value comparison

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Han - 29 Sep 2003 19:51 GMT

I'm using an Access query as my data source, which contains duplicate
records of the same person, but with different circumstantial data.

For example:

Mary Jones, Appointment 1
Mary Jones, Appointment 2
Fred Barns, Appointment 1
Jenny Smith, Appointment 1

Using mail merge query options, I will filter only the data required. For
example, Mary Jones has two appointment. In my letter, I want her name to
appear followed by each appointment.

Mary Jones
Appointment 1
Appointment 2

How can this be accomplished using Word fields?

It might help to know how the Access data is structured. The name and
appointment data is stored in separate tables and are joined by a user ID.

The conditional in Word needs a way to compare and filter the data.

All comments/suggestions are appreciated.

Thanks.

Reply to this Message

Doug Robbins - Word MVP - 30 Sep 2003 06:11 GMT

Hi Han,

I would do it all in Access. Word doesn't do it very well at all.
But, see 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

> I'm using an Access query as my data source, which contains duplicate
> records of the same person, but with different circumstantial data.
[quoted text clipped - 24 lines]
>
> Thanks.

Reply to this Message