Syntax Error When Field Name Starts with a Number (134411)


The information in this article applies to:

  • Microsoft Excel for Windows 95
  • Microsoft Excel for Windows 5.0
  • Microsoft Query
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

Modification Type:MinorLast Reviewed:8/15/2005
Keywords:KB134411
©2004 Microsoft Corporation. All rights reserved.