Summing negative merge fields in a Word table

[Margaret]

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?

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

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.