Click to See Complete Forum and Search --> : SQL Sum function not giving decimals [cjard: vb.net -> database]


advocation
November 13th, 2006, 08:13 PM
I need to use the sum function, but it is not adding up my decimal places an appears to be rounding the numbers. What can I do? Also, is there a way to set everything to have 2 decimal places. Thanks for your help again.

cjard
November 15th, 2006, 06:20 AM
No version of SUM does this as far as I know. If you provided more information like.. the database vendor, the sql and the table schema then it would be a lot easier to help you