Microsoft KB Archive/62400

Works Err Msg: Operator Missing or Not Valid

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

2.00

MS-DOS

= SUMMARY =

The error message “Operator missing or not valid” may occur upon entry of a formula if the first character in any field reference is a number. To correct the problem, rename the field so the first character is not a number.

The following database in List view is an example:

1stfield Field2 Total ——– —— —–

4              3                =1stfield + field2 69              9                =1stfield + field2 In Total, the reference to 1stfield is illegal because it begins with a number. Renaming “1stfield” to “Firstfield” or “Fieldone” solves the problem.

KBCategory: kbother KBSubcategory: dworkskb Additional reference words:

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