Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Percentage
Hi folks i am using this formula to merge from Access to a table in word
{={MERGEEFIELD "L2"}*100\#"0%"} which works fine. Except if there is no data to work on. if it is zero then the result is 0% thats ok but if it is null i get !Syntax Error, * how do i supress a null. Many thanks in advance |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Percentage
{ IF {MERGEFIELD "L2"} "" "{={MERGEFIELD "L2"} * 100 \# "0%"}" "" }
-- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Arnie" wrote in message news Hi folks i am using this formula to merge from Access to a table in word {={MERGEEFIELD "L2"}*100\#"0%"} which works fine. Except if there is no data to work on. if it is zero then the result is 0% thats ok but if it is null i get !Syntax Error, * how do i supress a null. Many thanks in advance |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Percentage
Doug hi that works fine where there is a null but now causes a Syntax error
where there is data "Doug Robbins - Word MVP" wrote: { IF {MERGEFIELD "L2"} "" "{={MERGEFIELD "L2"} * 100 \# "0%"}" "" } -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Arnie" wrote in message news Hi folks i am using this formula to merge from Access to a table in word {={MERGEEFIELD "L2"}*100\#"0%"} which works fine. Except if there is no data to work on. if it is zero then the result is 0% thats ok but if it is null i get !Syntax Error, * how do i supress a null. Many thanks in advance |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Percentage
The error this time i think refers the amount of " (!Syntax Error, " ) as the
previous error was !Syntax Error, * referring to the use of the * if that makes sense "Doug Robbins - Word MVP" wrote: { IF {MERGEFIELD "L2"} "" "{={MERGEFIELD "L2"} * 100 \# "0%"}" "" } -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Arnie" wrote in message news Hi folks i am using this formula to merge from Access to a table in word {={MERGEEFIELD "L2"}*100\#"0%"} which works fine. Except if there is no data to work on. if it is zero then the result is 0% thats ok but if it is null i get !Syntax Error, * how do i supress a null. Many thanks in advance |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Percentage
Did you use Ctrl+F9 to insert each pair of Field Delimiters { }?
-- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Arnie" wrote in message ... The error this time i think refers the amount of " (!Syntax Error, " ) as the previous error was !Syntax Error, * referring to the use of the * if that makes sense "Doug Robbins - Word MVP" wrote: { IF {MERGEFIELD "L2"} "" "{={MERGEFIELD "L2"} * 100 \# "0%"}" "" } -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Arnie" wrote in message news Hi folks i am using this formula to merge from Access to a table in word {={MERGEEFIELD "L2"}*100\#"0%"} which works fine. Except if there is no data to work on. if it is zero then the result is 0% thats ok but if it is null i get !Syntax Error, * how do i supress a null. Many thanks in advance |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Percentage
Dooooooh appoligies i had the last " "" in the wrong brackets works fine
thank you very much Arnie "Doug Robbins - Word MVP" wrote: { IF {MERGEFIELD "L2"} "" "{={MERGEFIELD "L2"} * 100 \# "0%"}" "" } -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "Arnie" wrote in message news Hi folks i am using this formula to merge from Access to a table in word {={MERGEEFIELD "L2"}*100\#"0%"} which works fine. Except if there is no data to work on. if it is zero then the result is 0% thats ok but if it is null i get !Syntax Error, * how do i supress a null. Many thanks in advance |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentage | Mailmerge | |||
percentage | Tables | |||
Percentage in form field | Tables | |||
Mail Merge Percentage | Mailmerge | |||
decimal to percentage | New Users |