 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / June 2006using iif statement
Hi. Can I tweak a mergefield contents so that if the field is blank it stays blank and if it contains a number it adds 1000000 to it? thanks You could try a nested field { IF "{ MERGEFIELD myfield }" = "" "" "{ ={ MERGEFIELD myfield }+1000000 }" } (all the {} need to be the special field braces you can insert using ctrl-F9. That won't work if your field can contain non-numeric text, e.g. " " or "abc" :-) Peter Jamieson > Hi. > Can I tweak a mergefield contents so that if the field is blank it stays > blank and if it contains a number it adds 1000000 to it? > thanks thanks for your response. I tried this { IF "{MERGEFIELD Control_Num}" = "" "" "{ ={ MERGEFIELD Control_Num }+1000000 }" } but ot deosn;t seem to work. I created the braces using ctrl + f9. Boots > You could try a nested field > [quoted text clipped - 12 lines] > > blank and if it contains a number it adds 1000000 to it? > > thanks Sorry it does work. I'd spelt control wrong. thanks > You could try a nested field > [quoted text clipped - 12 lines] > > blank and if it contains a number it adds 1000000 to it? > > thanks
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.