MSQUERY: Syntax Error When Field Name Starts with a Number

ID: Q134411

1.00 2.00 WINDOWS kbtool xlquery

The information in this article applies to:

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:

ARTICLE-ID: Q131162

TITLE     : "Syntax error in CREATE TABLE statement" with ODBC 2.0
            Drivers

KBCategory: kbtool KBSubcategory: xlquery

Additional reference words: XL5 2.00 5.00 5.0 5.0a 5.0c 7.00 MSQuery

Keywords          : xlquery 
Version           : 1.00 2.00
Platform          : WINDOWS

Last Reviewed: March 30, 1997