Syntax Error When Field Name Starts with a Number
Article ID: 134411
Article Last Modified on 8/15/2005
APPLIES TO
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0 Standard Edition
- Microsoft Query 2000
This article was previously published under Q134411
SYMPTOMS
In Microsoft Query, if a field name starts with a number, math operations
involving the field may result in the following error message:
Syntax Error
WORKAROUND
To work around this problem, change the field name so that it does not
start with a number.
REFERENCES
For additional information, please see the following article(s) in the
Microsoft Knowledge Base:
131162
MSQuery: "Syntax error in CREATE TABLE statement" with ODBC 2.0 Drivers
Additional query words: XL5 5.00 5.0 5.0a 5.0c 7.00 MSQuery
Keywords: KB134411