Calculated Fields in a Print Merge Contain Zero Values (112718)


The information in this article applies to:

  • Microsoft Works 3.0
This article was previously published under Q112718

SYMPTOMS

When fields that calculate values are placed in any merge document, some or all of the values in the fields may display as zero ("0"). This will occur if:
  1. The database associated with the merge document is closed. -or-

  2. The database associated with the merge document is open, but contains several thousand records.

RESOLUTION

Microsoft has confirmed this to be a problem in Works version 3.0 for Windows. This problem was corrected in Works version 3.0a for Windows.

To correct the problem, the database must be opened, and, if the database is large (that is, more than 2,000 records), you must force each entry in the field containing the formula to recalculate before printing.

To force a recalculation, use the following steps:
  1. Starting from the top, highlight each entry in the field containing the formula.
  2. From the Edit menu, choose Fill Down.
The values in the merge document will now print correctly.
Modification Type:MajorLast Reviewed:1/14/2000
Keywords:KB112718
©2002 Microsoft Corporation. All rights reserved.