if statement, if condition not met the show static text instead ofmergefield

[ghetto_banjo]

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!

 

[ghetto_banjo]

nevermind, i just found that "Insert Word Field" option for If
statements and I think i have it working...