surpressing or adding words between fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 31 Mar 2004 06:08 GMT

Newbie to this. Trying to merge information from Access 2003 to a Word
2003. Fields in Access like LastName, MaleName, & FemaleName. If there
is a male and female name in database I want it to show in the merge
as "Last Name", "MaleName" & "FemaleName" (Smith, John & Lisa) if it
is missing either the Male or Female name in that database I want to
suppress the & sign and just show whichever name it is. (Smith, Lisa)
Same thing database has a Real Address and Mailing address. If they
are the same I want the merge to only show one address, but if they
are different I want it to show both.
I was thinking that it would use the IF...Then...Else but I can not
seem to make it work.
Thanks

Reply to this Message

Doug Robbins - Word MVP - 31 Mar 2004 13:51 GMT

As the data is in Access, I would use a query in Access to achieve the
output that you require and then use that query as the datasource.

Databases are better at data manipulation than word processors.

Signature

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

> Newbie to this. Trying to merge information from Access 2003 to a Word
> 2003. Fields in Access like LastName, MaleName, & FemaleName. If there
[quoted text clipped - 8 lines]
> seem to make it work.
> Thanks

Reply to this Message

Rate this thread: