ID: Q113572
1.00 WINDOWS kbother kbdocerr kbprb docerr kbtool
The information in this article applies to:
In Microsoft Query version 1.0, you receive the message "Syntax error" when you try to enter a custom expression that contains a decimal value but does not have a numeric value before the decimal point.
To avoid receiving this error message when you ener a custom expression that contains a decimal value, precede the value with a zero (0). For example, enter the value .09 as 0.09.
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in in the version of Microsoft Query that ships with Microsoft Excel version 5.0c for Windows.
Page 99 of the "Microsoft Query User's Guide" explains how to perform a calculation using your own expression in the following passage:
For instance, to find the sales commission described in the example,
you would type Sum(ORDER_AMT)*.15 in the column heading.
The following is an example of the correct format for this equation (the decimal value contains a zero in front of the decimal point):
Sum(ORDER_AMT)*0.15
"Microsoft Query User's Guide," version 5.0, Chapter 5, "Creating Your Own Expressions to Perform Calculations"
KBCategory: kbother kbdocerr kbprb kbtool KBSubcategory: xlquery xlwin
Additional reference words: 1.00 docerr
Keywords : xlquery xlwin
Version : 1.00
Platform : WINDOWSLast Reviewed: September 15, 1996