Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mergefield1 minus mergefield2
Hi
I've had a quick search of the group and can't find anything that directly relates to this question, so thought i'd go ahead and ask it: I'm struggling to create the correct equation to produce the result of a difference between two numbers. I'm simply attemping {= { MERGEFIELD "FIELD1" }-{ MERGEFIELD "FIELD2" } \#£,0.00 }. However, it gives a syntax error. Is there a better way of doing this (some sort of built in operator perhaps?) or could you perhaps suggest why the syntax error occurs? Should it even be done with a bookmark reference instead (although i need it to populate correctly first time without the need for a field refresh to force the calculation)? Any help gratefuly received! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mergefield1 minus mergefield2
Did you insert all the field boundaries with CTRL+F9 or merely type the ones
around the Mergefields? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Duncan wrote: Hi I've had a quick search of the group and can't find anything that directly relates to this question, so thought i'd go ahead and ask it: I'm struggling to create the correct equation to produce the result of a difference between two numbers. I'm simply attemping {= { MERGEFIELD "FIELD1" }-{ MERGEFIELD "FIELD2" } \#£,0.00 }. However, it gives a syntax error. Is there a better way of doing this (some sort of built in operator perhaps?) or could you perhaps suggest why the syntax error occurs? Should it even be done with a bookmark reference instead (although i need it to populate correctly first time without the need for a field refresh to force the calculation)? Any help gratefuly received! |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mergefield1 minus mergefield2
I inserted all field boudaries with Ctrl+f9 then typed the codes manually
inside. "Graham Mayor" wrote: Did you insert all the field boundaries with CTRL+F9 or merely type the ones around the Mergefields? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Duncan wrote: Hi I've had a quick search of the group and can't find anything that directly relates to this question, so thought i'd go ahead and ask it: I'm struggling to create the correct equation to produce the result of a difference between two numbers. I'm simply attemping {= { MERGEFIELD "FIELD1" }-{ MERGEFIELD "FIELD2" } \#£,0.00 }. However, it gives a syntax error. Is there a better way of doing this (some sort of built in operator perhaps?) or could you perhaps suggest why the syntax error occurs? Should it even be done with a bookmark reference instead (although i need it to populate correctly first time without the need for a field refresh to force the calculation)? Any help gratefuly received! |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mergefield1 minus mergefield2
What is your data source?
If you display the results of the individual mergefields on their own, what do you see (could they be, for example, texts like £1,234.56 that look like numbers but are not)? If you display { ={ MERGEFIELD "FIELD1" } } and { ={ MERGEFIELD "FIELD2" } } on their own, do they display OK? How about with the numeric format switch added? Do you have any SKIPIF fields in your Mailmerge main document? Peter Jamieson "Duncan" wrote in message ... I inserted all field boudaries with Ctrl+f9 then typed the codes manually inside. "Graham Mayor" wrote: Did you insert all the field boundaries with CTRL+F9 or merely type the ones around the Mergefields? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Duncan wrote: Hi I've had a quick search of the group and can't find anything that directly relates to this question, so thought i'd go ahead and ask it: I'm struggling to create the correct equation to produce the result of a difference between two numbers. I'm simply attemping {= { MERGEFIELD "FIELD1" }-{ MERGEFIELD "FIELD2" } \#£,0.00 }. However, it gives a syntax error. Is there a better way of doing this (some sort of built in operator perhaps?) or could you perhaps suggest why the syntax error occurs? Should it even be done with a bookmark reference instead (although i need it to populate correctly first time without the need for a field refresh to force the calculation)? Any help gratefuly received! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Non-breaking minus sign | Microsoft Word Help | |||
Change minus sign. | Microsoft Word Help | |||
Macro for aligning on plus/minus? | Tables | |||
Date field minus 1 day = yesterday | Mailmerge | |||
Minus plus | Microsoft Word Help |