Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/39447

From BetaArchive Wiki

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.