Microsoft KB Archive/65127

Works: Using Numbered Field Name in Summary Report Row

PSS ID Number: Q65127 Article last modified on 06-12-1996

2.00

MS-DOS

= SUMMARY =

To use a field name that is a number (such as 789) within a formula in a summary row in a database report, the numbered field name must be enclosed within single quotation marks.

For example, the formula =sum(789) will NOT return the correct total of a column; the formula =sum(‘789’) will. Note that this is the same ways fieldnames funvction in Form and List views.

= MORE INFORMATION =

Using the quotation marks causes Works to recognize characters as text rather than as a number; therefore, this will enable Works to used fieldname digits correctly.

KBCategory: kbother KBSubcategory: dworkskb Additional reference words:

=
================================================================ Copyright Microsoft Corporation 1996.