Calculated Field Always Shows Up as Zeroes

S

suzshook

I am using Word 2000, and trying to mailmerge a document that contains
calculated field (=SUM(RIGHT)) - this field always shows up in my merge
document as $000.00, and never the calculated value, though I ca
successfully select records based on that value. For example, I want t
select the records where this field is greater than or equal to 300.
This works, and the correct records are selected. However, one of th
fields in the merged document prints the data in this calculated field
and all the records print zeros. I also get the message "Record
contained too many data fields" several times when I try to mailmerge.
Is there a way to print this calculated field correctly in a mailmerg
document? Thanks for any help! Su
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top