Microsoft KB Archive/40337

Works: Fractions Interpreted as Dates in 2.0 and Earlier

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

1.00 1.05 2.00

MS-DOS

=
========================================================= 1.00 1.05 2.00 MS-DOS kbother

= SUMMARY =

When you enter a fraction, such as 3/8, in the Database module of Works versions 1.0, 1.05, and 2.0, Works interprets these fractions as dates.

To allow Works to recognize a fraction as a number rather than a date:

  Create a three fields in your database document: one for the numerator (for example, Num), one for the denominator (for example, Denom), and one for the value of the number in decimal form (for example Decimal).   With the document in form view, type the following equation in the Decimal field (the field you created to contain the value of the number in decimal form): =Num/Denom   Type the denominator of the fraction in the Denom field and the numerator in the Num field. The Decimal field will now contain the value of the number in decimal form. 

If one of the records is already in decimal format, then enter that number directly in the Decimal field. If you later want to enter the fraction, do the following:


 * 1) Enter the denominator and numerator in the appropriate fields.
 * 2) Select the Decimal field.
 * 3) From the Edit menu, choose Clear to clear the Decimal field.

= MORE INFORMATION =

Works version 3.0 does not interpret fractions as dates. Works 3.0 will accept fractions, such as 3/8, as fractional numbers.

KBCategory: kbother KBSubcategory: dworkskb

= Additional reference words: 1.x 1.00 1.05 2.00 3.00 =

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