Pass-Through Query Rounding Off

[Guest]

Good morning

I'm trying to SUM data in an Oracle database, and plop it into my table. I'm using ODBC through a DSN with the Microsoft ODBC driver for Oracle. The column I'm summing is a two decimal field, but when my query is done executing, I have no decimals.

I created a select query to pull the data, and an append query to apply it to the table, and the select query is what is returning the data as rounded. If I execute the same query through SQLPlus I don't have this problem

I'm accessing Oracle 8i through Access 2000

Thanks in advance for your help

-Brad

 

[Jeff Boyce]

Brad

Have you explicitly "typed" your result as ?integer before attempting to do
your update?

 

[Guest]

Is there a way to type a select query? If so, I accidentally did it somewhere. But in the pass-through query properties I'm not able to find that field

If I just execute the select query and look at the results in the datasheet view, the cents are trimmed off

Thanks for your help

-Brad

 

[Jeff Boyce]

Brad

Take a look at the CCur() function (convert to currency). You could make a
field in your select query into a currency (up to four decimal places) type,
and/or you could right-click on the field in your query grid and set the
decimal places to ?2...