View Single Post
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;;"



Graham Mayor - Word MVP

My web site
Word MVP web site

"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

{IF =0 "" ""}

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

Thanks a Million for the help,