Thread Tools Display Modes
  #1   Report Post  
suzshook suzshook is offline
Junior Member
Posts: 2
Default Calculated Field Always Shows Up as Zeroes

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge Data - calculated field יריב החביב Microsoft Word Help 2 December 2nd 08 12:28 PM
Field calculation error using calculated dates IPandA Mailmerge 0 January 7th 08 11:44 PM
Using a calculated field elsewhere in a document Jay Strauss Tables 1 March 17th 07 07:33 AM
My zip code field on the mail merge drops leading zeroes, why? PETEinBOSTON Mailmerge 1 March 2nd 07 04:01 PM
zeroes not printing in zip code field when merging from excel to w Debbie Love Mailmerge 1 April 17th 06 05:11 PM

All times are GMT +1. The time now is 06:14 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Word"