Hi,
I am having problems running the following code:

'Here we determine the amount of tax to apply if the order is taxable.
SQLStmt = "SELECT Sum((TOTAL) * " & TaxAmt & &#34 AS Tax "
'SQLStmt = "SELECT Sum((TOTAL) * .9999) AS Tax "
'SQLStmt = "SELECT Sum((TOTAL) * 1) AS Tax "
SQLStmt = SQLStmt & "FROM ORDERS WHERE "
SQLStmt = SQLStmt & " ORDER_ID = " & Session("ORDER_ID&#34 & " "
Response.Write SQLStmt
Set RSTax = Connection.Execute(SQLStmt)

TaxAmt comes from a session variable.

If I substitute a number >=1 for "TaxAmt", the code functions(wrong
answer). If the TaxAmt is <1, as it is when using the &#34;TaxAmt&#34;, I get the
following error:

SELECT Sum((TOTAL) * .9999) AS Tax FROM ORDERS WHERE ORDER_ID = 48
Microsoft OLE DB Provider for ODBC Drivers error &#39;80004005&#39;
[Microsoft][ODBC Microsoft Access Driver] Scaling of decimal value resulted
in data truncation.
/storeTest/order.asp, line 166

Does anyone have any ideas how to change the SQL call to make it work?

Thanks,
Kevin