[Arnie[_2_]]

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

[Doug Robbins - Word MVP]

{ 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

[Arnie[_2_]]

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

[Arnie[_2_]]

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

[Doug Robbins - Word MVP]

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

[Arnie[_2_]]

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