Sum 2 data source fields to create 1 merge field possible in Word 2002?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jason - 08 Oct 2003 21:47 GMT

I am trying to take 2 fields from a data source, sum
them, and create 1 merge field in a document. I do not
want to put either of the fields I want to sum in the
document, just their sum. Is this even possible? Does
anyone here have an idea how to do this? Any advice
would be appreciated. TIA

Reply to this Message

Greg Maxey - 08 Oct 2003 22:15 GMT

Jason

Try { =sum({Mergefield A},{Mergefield B})}. Where { } is entered using
CTRL+F9 and A, B are your mergefield names.

Signature

Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
Remove the obvious (wham...m) to reply in e-mail

> I am trying to take 2 fields from a data source, sum
> them, and create 1 merge field in a document. I do not
> want to put either of the fields I want to sum in the
> document, just their sum. Is this even possible? Does
> anyone here have an idea how to do this? Any advice
> would be appreciated. TIA

Reply to this Message

Jason - 09 Oct 2003 21:26 GMT

Worked like a charm! Thanks so much Greg. It even let
me do the subtraction I need to do elsewhere.

Jason

>-----Original Message-----
>Jason
[quoted text clipped - 10 lines]
>
>.

Reply to this Message