R
Rudy M.
I am running a query and I keep getting a syntax error message 3075. It
apparently doesn't like the decimals, as it keeps thinking the period in a
decimal number should be a comma. Here is a cut of a part of the SQL query,
and then I will input what it does with the decimal:
Points: IIf([Product] In ('SIMO','CC2ND') And
([HomeF]='Y'),CDbl(1),IIf([Product] In ('SIMO','CC2ND') And
([HomeF]='N'),CDbl(1.857),IIf([Product]='SA' And
and it puts in the error message, (for example the 1.857 number) this:
(1].[857) and it says it should be a comma. I have tried this without any
parens and the CDbl and with just the parens and with the parens with the
CDbl, and I still get the same error.
What do I do?
apparently doesn't like the decimals, as it keeps thinking the period in a
decimal number should be a comma. Here is a cut of a part of the SQL query,
and then I will input what it does with the decimal:
Points: IIf([Product] In ('SIMO','CC2ND') And
([HomeF]='Y'),CDbl(1),IIf([Product] In ('SIMO','CC2ND') And
([HomeF]='N'),CDbl(1.857),IIf([Product]='SA' And
and it puts in the error message, (for example the 1.857 number) this:
(1].[857) and it says it should be a comma. I have tried this without any
parens and the CDbl and with just the parens and with the parens with the
CDbl, and I still get the same error.
What do I do?