Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In typing dates in Word, i.e. "January 12" how do you keep the "1. | Microsoft Word Help | |||
word xp crashes after macros are recorded | Microsoft Word Help | |||
Continuous breaks convert to next page breaks | Microsoft Word Help | |||
macro in word | Microsoft Word Help | |||
Word 2003 and Access 2003 Mail Merge question | Microsoft Word Help |