Microsoft KB Archive/79968

= Self-Referencing Formula Returns Incorrect Answer =

Article ID: 79968

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition

-



This article was previously published under Q79968



SUMMARY
A self-referencing formula in a Works for Windows database will start returning an incorrect answer in record 769. This problem was corrected in Works for Windows 2.0a.



WORKAROUND
Split the database into several databases, each with 768 records or less. Self-referencing formulas work correctly in Works for MS-DOS.



The Balance Field
The following formula entered in the Balance field is an example of a self-referencing formula:

=Balance-Check+Deposit

The Balance field is both the field where the formula is entered and a field in the formula. This is what makes it a self-referencing formula.

The above formula would return an incorrect balance in record 769, and a negative value that is the inverse of whatever was entered in the Check field in the records below 769.

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

Additional query words: 2.0 calculate self reference referencing

Keywords: KB79968

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.