Works: Running Total Does Not Recalculate (79120)
The information in this article applies to:
- Microsoft Works 2.0
- 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 "=Total+Price"
(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.
| Modification Type: | Major | Last Reviewed: | 9/25/2003 |
|---|
| Keywords: | KB79120 |
|---|
|