M
Matthew Pfluger
I have and Access 2007 database connected to and IS400 database through an
iSeries ODBC. I am pulling cost information from a table and filtering for a
few parameters. The cost comes in as a decimal with up to 4 places.
Everything works great until I start to use aggregate functions in my query.
For example, I turned on the Totals row, and all cost information was
truncated to its integer value only (i.e. 0.6251 --> 0, 384.6 --> 384). I
also tried "Unique Values" and the same thing happened. I'm able to perform
calculations on the data without aggregate functions, but I need to be able
to GROUP BY and SUM the data in these queries.
Can anyone provide some clues as to what's going on? Is this typical
behavior of aggregate functions?
Thanks,
Matthew Pfluger
iSeries ODBC. I am pulling cost information from a table and filtering for a
few parameters. The cost comes in as a decimal with up to 4 places.
Everything works great until I start to use aggregate functions in my query.
For example, I turned on the Totals row, and all cost information was
truncated to its integer value only (i.e. 0.6251 --> 0, 384.6 --> 384). I
also tried "Unique Values" and the same thing happened. I'm able to perform
calculations on the data without aggregate functions, but I need to be able
to GROUP BY and SUM the data in these queries.
Can anyone provide some clues as to what's going on? Is this typical
behavior of aggregate functions?
Thanks,
Matthew Pfluger