Works: Creating a Running Total in the Database
PSS ID Number: Q39447 Article last modified on 10-16-1998
1.00 1.05 2.00 3.00
MS-DOS
====================================================================== 1.00 1.05 2.00 3.00 MS-DOS kbother
The information in this article applies to: |
- Microsoft Works for MS-DOS, versions 1.x, 2.0, and 3.0 |
SUMMARY
In the Microsoft Works for MS-DOS Database, you can accumulate the total for a field as the entries are made (a running total); however, the field that is to contain the running total must contain a formula that references itself.
For example, an imaginary database contains two fields titled “FIELD1” and “FIELD2”. To make FIELD2 contain a running total of all the values entered in FIELD1, in Database List View, enter the formula “=FIELD1+FIELD2” (without the quotation marks) into record 1 (the first row) of FIELD2. The result will be a running total that accumulates in FIELD2.
KBCategory: kbother KBSubcategory: dworkskb
Additional reference words: 1.00 1.05 2.00 3.00
Version : 1.00 1.05 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.