Reply
 
Thread Tools Display Modes
  #1   Report Post  
Joshua Briley
 
Posts: n/a
Default Merge from Access; formatting in Word

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
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

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
"Joshua Briley" wrote in message
...
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



  #3   Report Post  
 
Posts: n/a
Default

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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
In typing dates in Word, i.e. "January 12" how do you keep the "1. Carol Microsoft Word Help 2 January 12th 05 09:09 PM
word xp crashes after macros are recorded kharris0405 Microsoft Word Help 3 January 11th 05 11:50 PM
Continuous breaks convert to next page breaks Jennifer Hunt Microsoft Word Help 2 December 30th 04 06:45 PM
macro in word js Microsoft Word Help 1 December 28th 04 04:01 AM
Word 2003 and Access 2003 Mail Merge question HD87glide Microsoft Word Help 2 December 15th 04 03:29 PM


All times are GMT +1. The time now is 03:10 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"