Microsoft KB Archive/79120

= Works: Running Total Does Not Recalculate =

Article ID: 79120

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a

-



This article was previously published under Q79120



SUMMARY
If records are deleted from a database that has a running total, the running total does not recalculate unless you perform an operation to force it to recalculate. This has been corrected in Works for Windows 3.0 when you choose Cut from the Edit menu to delete the record (this problem still occurs if you choose Delete Record/Field from the Insert menu).



MORE INFORMATION
It is possible to create a field in the database that will keep a running total of another field. For example, consider two fields: one called Total and one called Price. Placing the formula &quot;=Total+Price&quot; (without the quotation marks) in the Total field will cause a running total of the Price field to appear.

If this has been done, and if records are then deleted from the database, the running total does not recalculate unless you perform an operation to force it to recalculate.



WORKAROUND
Put your cursor in any field with a formula in it, press the F2 key to enter edit mode, and then press ENTER without changing the contents of the field. This will force the database to recalculate.

Additional query words: 2.0 3.0

Keywords: KB79120

-

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

© Microsoft Corporation. All rights reserved.