Merge from Access; formatting in Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joshua Briley - 29 Nov 2004 20:56 GMT

Hello,

Thanks in advance to whomever posts a response to this
question. I have a word document that has numerous
merged fields from an Access DB. One of the merged
fields is a value that is followed by a static "mg/L"
statement in word. However, this value is sometimes
null. In my report, I'd like the "mg/L" to be removed if
the merged value is null. Is there a way to accomplish
this? Any advice is greatly appreciated.

Sincerely,
Josh

Reply to this Message

Doug Robbins - 30 Nov 2004 00:59 GMT

You can either use and If...then...else field in Word that tests for the
value and inserts the value plus the units if it is not null and inserts
nothing if it is, or, what I would do is create a query in Access that does
that. Databases are better for data manipulation than Word processors.

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> Hello,
>
[quoted text clipped - 9 lines]
> Sincerely,
> Josh

Reply to this Message

- 01 Dec 2004 03:08 GMT

Josh,

You need to use the If Then Else command. On the mail
merge toolbar click insert merge field and then drop down
to the If...Then. I think what you'll want is if the
merge field is not blank, then insert your text. Good
luck!

Reply to this Message