Access to Microsoft Word Merge (simple math)

[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

 

[Arvin Meyer [MVP]]

Why don't you do the subtraction in a query before you merge the data?

 

[Mark Andrews]

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

 

[Mark Andrews]

Thanks I'll look more closely at the help.

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)

 

[Arvin Meyer [MVP]]

You do calculations in Word tables similar to the way they are done in
Excel, i.e. using cell references so for instance, if you wanted to add the
second and fourth cells in the fifth cell in row b, you would write:

=SUM(b2,b4)

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Mark Andrews]

Thanks

You do calculations in Word tables similar to the way they are done in
Excel, i.e. using cell references so for instance, if you wanted to add
the second and fourth cells in the fifth cell in row b, you would write:

=SUM(b2,b4)

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com