Microsoft KB Archive/131467

= Works Error Occurs in Database Formula with Numeric Field Name =

Article ID: 131467

Article Last Modified on 10/6/2003

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 3.0a
 * Microsoft Works 3.0b

-



This article was previously published under Q131467



SYMPTOMS
In a Works database, you receive an error message when you attempt to use a formula containing a reference to a field name that starts with a number.

Some of the possible error messages include:

Operator missing or not valid.

Reference not valid or wrong operand type.

The formula is not typed correctly.

The formula contains an error.



WORKAROUND
To use the field name and avoid the error message, do one of the following.

Method 1

Enclose the field name in the formula with single quotation marks.

Method 2 Change the database field name. To change the field name, do the following:

Works 2.0x or 3.0x:
 * 1) On the Edit menu in List View of the database, click Field Name.
 * 2) Type a name that doesn't begin with a number.

Additional query words: w_works 2.00x 3.00 3.00a 3.00b

Keywords: kberrmsg kbprb KB131467

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.