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