Knowledge Base

Works: Self-Referencing Formula Does Not Update Automatically

Article ID: 126808

Article Last Modified on 10/6/2003

Microsoft Works 2.0 Standard Edition
Microsoft Works 2.0a
Microsoft Works 3.0 Standard Edition
Microsoft Works 3.0a
Microsoft Works 3.0b

This article was previously published under Q126808

SYMPTOMS

Self-referencing formulas in the Database module do not automatically recalculate when a record is deleted.

WORKAROUND

Save, close and reopen the file. Works will recalculate the formula.

Manually re-enter any entry in any field that is being referenced by the formula. To quickly re-enter data, press the F2 key and then press Enter.

STATUS

This problem has been fixed in Works 4.0, 4.5, and 4.5a for Windows 95.

MORE INFORMATION

A self-referencing formula uses the name of the field in which it is entered. For example, the following formula entered in a database field named "Balance" would be self-referencing:

   =Balance-Check+Deposit

Additional query words: 2.00 2.00a 3.00 3.00a 3.00b w_works reference updated running total

Keywords: kbprb KB126808