using iif statement
Sorry it does work. I'd spelt control wrong. thanks
"Peter Jamieson" wrote:
You could try a nested field
{ IF "{ MERGEFIELD myfield }" = "" "" "{ ={ MERGEFIELD
myfield }+1000000 }" }
(all the {} need to be the special field braces you can insert using
ctrl-F9.
That won't work if your field can contain non-numeric text, e.g. " " or
"abc" :-)
Peter Jamieson
"Boots" wrote in message
...
Hi.
Can I tweak a mergefield contents so that if the field is blank it stays
blank and if it contains a number it adds 1000000 to it?
thanks
|