Want to subtract 10 from a merged field value.

[pk]

Hi,
I want to subtract 10 from a merged field value. The data
is stored as a string in the .mdb database. Can we do this
calculation?

Prasad.

 

[Peter Jamieson]

As long as the string is recognised by Word as numeric, you should be able
to use an { = } field, e.g.

{ = { MERGEFIELD mynumber }-10 }

where the {} are inserted using ctrl-F9.

You could also consider creating a query in Access with the necessary
calculation and using that as the data source.

 

[Greg Maxey]

PK,

Try { =({YourMergeFieldName}-10) }. Where { } is entered with CTRL+F9