I am testing a query in Visual Basic's Data Environment
designer. The returned information includes "currency"
data. When I run a group by, SUM on the currency value, it
calculates the total amount correctly. If I leave it as a
normal select statement, showing all values, it is
truncating decimal values when it ends with ##0.00.
For Example:
110.00 = 11
210.00 = 21
90.00 = 9
This appears consistent. When running the same query in
microsoft Query or in Access (via the same ODBC
connection) I am not seeing the errors. Nor does the
problem present itself in the adodb.recordsets i'm using,
though it does in VB.
does anyone else have any knowledge to lend on this
subject?
-Brian
>> Stay informed about: Truncated Decimal Points