Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
ghetto_banjo ghetto_banjo is offline
external usenet poster
 
Posts: 2
Default if statement, if condition not met the show static text instead ofmergefield

I am merging from an access database into a word document. One merge
field, AmountClaimed, is numeric. If this mergefield = 0, I want Word
to show "TBD" (without quotes), but if it is not = 0, then i want to
show the mergefield AmountClaimed.

This is what I have this is not working. I am messed up on the
placement of all the brackets and quotes big time. I also dont know
what delimited to put around my static text, right now its double
quotes.

{ IF {MERGEFIELD AmountClaimed 0 "{MERGEFIELD AmountClaimed \#
0.00}" "{"TBD"}}


When I hit the button to view Merged Data, i still just see the above
mess of a conditonal.


Any help would be greatly appreciated.


Thanks!
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
ghetto_banjo ghetto_banjo is offline
external usenet poster
 
Posts: 2
Default if statement, if condition not met the show static text insteadof mergefield

nevermind, i just found that "Insert Word Field" option for If
statements and I think i have it working...
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
How do I convert auto paragraph numbering to static text numbers? Lagoyu Microsoft Word Help 1 December 10th 08 04:40 PM
Some static text boxes, some free text Anna New Users 2 June 4th 08 10:09 AM
convert bibliography to static text mad as hell Microsoft Word Help 3 May 22nd 08 03:08 AM
statement only show up on the last page in the footer songinthedark Microsoft Word Help 1 May 20th 08 09:44 PM
Replace Static with Variable but leave alone text between them Deborah K Microsoft Word Help 1 June 29th 05 09:33 AM


All times are GMT +1. The time now is 07:48 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"