A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Mail Merge Forumula's



 
 
Thread Tools Display Modes
  #1  
Old June 4th, 2010, 12:21 PM posted to microsoft.public.word.mailmerge.fields
Fionny
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
Ads
  #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



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:31 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.