Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Fionny Fionny is offline
external usenet poster
 
Posts: 1
Default Mail Merge Forumula's

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
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
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



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
Error: Mail merge not completed....doesnot contain mail merge fiel Abhishek Dadu Mailmerge 3 January 1st 09 06:00 AM
Mail-Merge: Can we have master detail relationship or multiple entities in word Mail-Merge? gmax2006 Microsoft Word Help 1 March 28th 07 06:28 PM
Take Mail Merge in Word back the the Mail Merge Helper 1,2,3 Form. Chris Green Mailmerge 5 October 8th 05 03:51 PM
Proteced Form with Mail Merge Section-Mail Merge is "lost" whe F. Ferrer Microsoft Word Help 0 February 2nd 05 09:27 PM
mail merge doc with further linked/embedded mail merge docs not playing the game Rob Cowlard Mailmerge 3 January 8th 05 10:15 AM


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