Access to Microsoft Word Merge (simple math)

  • Thread starter Thread starter Mark Andrews
  • Start date Start date
M

Mark Andrews

I have setup a Microsoft word merge from data in a Microsoft Access database
using Albert Kallal's code (that part works great), I am merging a lot of
fields that have numbers in them and wondering if it's possible to do simple
math in Microsoft Word. There are too many combinations of how the user
might want to do math to include all possibilities from the query in Access
that pulls all the data.

Example: Create a document that has two merge fields and subtracts the two
fields to get the difference.

I played with things like:

{=({MERGEFIELD "Field1"} - {MERGEFIELD "Field2"}) }

but can't figure out how to make it work or if this is possible.

I know this is more of a Microsoft Word question. I don't really use Word
very much (as you can probably tell).

Thanks in advance,
Mark
 
Because as I stated in the question there are just too many combinations.
The amount of data available as word merge fields is already large. So if
it's possible to do math in Word I want to learn how so I can teach the
users. Then they can do the calculations that make sense for them.

Do you know if it's possible to do math in Word?

Mark
 
Thanks I'll look more closely at the help.

Steve said:
Hi Mark,

Yes, you can do math in Word. Word uses the same operators as Access and
Word has a set of built-in functions. Look in the Help file for Math. If
you have Word 97, look there for the best help (of course!!).

Steve
(e-mail address removed)
Click to expand...
 
Back
Top