Microsoft KB Archive/23599

Works 1.0: Database Calculation Produces Minus Zero “(0.00)”

PSS ID Number: Q23599 Article last modified on 10-16-1996

1.00 1.10

MACINTOSH

Summary:

Sometimes a computed field in a Microsoft Works database will produce a minus zero “(0.00)”. Also, selection rules to find all numbers greater than zero will sometimes return records containing zeros.

This problem sometimes occurs because Works stores a large number of decimal places, although the field may be formatted to display only two places. An example of a formula to ensure a true zero for a given calculation is as follows:

=IF(Abs(Field1-Field2)<0.01,0,Field1-Field2)

KBCategory: kbother kbprb KBSubcategory:

= Additional reference words: 1.00 1.10 mswksdb =

Copyright Microsoft Corporation 1996.