Merge from Access; formatting in Word

J

Joshua Briley

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
 
D

Doug Robbins

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.

--
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
 
G

Guest

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top