Microsoft KB Archive/64593

Works: Blank Formula Results when Printing Database Reports

PSS ID Number: Q64593 Article last modified on 06-18-1996

1.00 1.05 2.00

MS-DOS

Summary:

When you enter a formula in a report from the Microsoft Works version 1.0, 1.05, and 2.0 Database, the formula result will be blank when the report is printed if any of the cells referenced by the formula are blank.

For example, consider the following Database information:

Field1 Field2 —— ——

1            3 2             4 3               1 5             2 When the formula “Field1+Field2” is placed in a report, the third and fourth record rows of the report will be blank when printed. If a value of 0 (zero) is entered in the blank fields, the formula totals and prints correctly.

Microsoft has confirmed this to be a problem in Works for MS-DOS version 2.0. This problem was corrected in Works version 3.0.

KBSubcategory: dworkskb

=
================================================================ Copyright Microsoft Corporation 1996.