View Single Post
  #2  
Old June 4th, 2010, 12:42 PM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 18,297
Default Mail Merge Forumula's

You can't put field brackets around inserted fields as you have done. Toggle
the display with ALT+F9 then you should have something like

{IF { MERGEFIELD Purchase_Line_Quantity } = "0" "" "{ MERGEFIELD
Purchase_Line_Quantity }" }

Though frankly adding a formatting switch will work as well

{ MERGEFIELD Purchase_Line_Quantity \# "0;;"}

If the quantity may exceed 1,000 add a comma between the opening quote and
the 0 thus \# ",0;;"

See http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"Fionny" wrote in message
...
Hi All,

Im in the process of creating a stylesheet for reports from NAV 5.0 and
require a formula to be entered to prevent 0's for being Displayed.

What I am Entering is:

{IF { «Purchase_Line_Quantity» } = "0" "" "{ «Purchase_Line_Quantity» }" }

But when I save this and close it changes the whole thing back to just
this:

{IF =0 "" ""}

I am at a total loss as to how do this.

Thanks a Million for the help,

Regards,
Fionn



Ads