Microsoft KB Archive/63437

Works: Database Does Not Update or Recalculate After Deleting

PSS ID Number: Q63437 Article last modified on 10-16-1998

2.00 3.00

MS-DOS

=
========================================================= 2.00 3.00 MS-DOS kbother

= SYMPTOMS =

In versions 2.0 and 3.0 of Microsoft Works for MS-DOS, if there is a formula in a field in the Database, such as “=Field3- Field2,” Works does not recalculate the Database after a record is deleted from form view or list view.

= WORKAROUND =

To work around this problem, move to the affected field, press F2, then press ENTER. This forces Works to recalculate the Database after you delete a record.

= MORE INFORMATION =

To reproduce this problem, enter the following data in Field1 and Field2. In Field3, type the formula “=Field3-Field2” (without the quotation marks). The database should be displayed as follows:

Field1 Field2 Field3 —— —— ——

85 AAA 20 65 BBB 10 55 CCC 15 40

Note that 85 is the beginning number and that 20 (Field2 AAA) is what is being subtracted to equal 65, and so forth. If you insert a row or record between AAA and BBB, Works updates Field3. The database would appear as follows:

Field1 Field2 Field3 —— —— ——

85 AAA 20 65 DDD 5 60 BBB 10 50 CCC 15 35

However, if you delete the row or record BBB from the first example, Works would not update Field3 unless a report is generated or the database is saved, closed, and reopened. The database would appear as follows after the deletion:

Field1 Field2 Field3 —— —— ——

85 AAA 20 65 DDD 5 60 CCC 15 35

Field3 DDD = 60 minus Field2 CCC = 15 should equal 45 after record BBB is deleted. However, Works does not recalculate the formula and the incorrect total appears. You can correct this problem by moving to Field3 and pressing F2; this places the formula in edit mode on the status bar. If you make no changes and press ENTER, the field is properly recalculated.

Note: You can also close and reopen the database file, or generate a report to obtain recalculation.

KBCategory: kbother KBSubcategory: dworkskb

= Additional reference words: 2.00 3.00 =

Version : 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.