Microsoft KB Archive/70221

Works: Database Formula Using a Month Name Inserts a Number

PSS ID Number: Q70221 Article last modified on 03-11-1997

1.00 1.05 2.00

MS-DOS

=
========================================================= 1.00 1.05 2.00 DOS kbotherWK

= SUMMARY =

In Microsoft Works version 2.00, names of months can be used as field names; however, when using formulas that make one field equal to another field and the name of a month is in the formula, the field name must be entered as follows:

=(fieldname)

If you don’t include the parentheses, the field contents will be the numeric equivalent of January rather than the actual contents from the January field.

Example
If the field called January has a total that you want to copy to the field called Summary, place the cursor in the Summary field cell where you want the January total and type “=(January)” (without the quotation marks).

KBCategory: kbother KBSubcategory: dworkskb Additional reference words: ====================================================================== Keywords : dworkskb kbother Version : 1.00 1.05 2.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1997.