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