[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