Summing negative merge fields in a Word table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Margaret - 23 Dec 2003 05:41 GMT

I'm using Office 2000 and merging currency data from Access2000 into a Word2000 table. I have the formula: {=sum(left)\#"$,0"} to sum two columns in the table. This formula works fine if the merge fields contain positive data only, however, if the 2 merge fields both contain negative numbers the result prints as $0 and if the one of the fields contains a positive amount, then the result prints the actual positive merge field value - ie it disregards the negative amount.

Any ideas for a fix?

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 23 Dec 2003 10:45 GMT

Hi Margaret,

I would do the addition in Access, but I believe that your problem is that
the numeric formatting switch that you have added to the fields only allows
for a positive result. Try replacing it with

\# "$0;($,0)"

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> I'm using Office 2000 and merging currency data from Access2000 into a Word2000 table. I have the formula: {=sum(left)\#"$,0"} to sum two columns

in the table. This formula works fine if the merge fields contain positive
data only, however, if the 2 merge fields both contain negative numbers the
result prints as $0 and if the one of the fields contains a positive amount,
then the result prints the actual positive merge field value - ie it
disregards the negative amount.

> Any ideas for a fix?

Reply to this Message