SQL SUM calculation decimal??

ed · Mar 25, 2004

I defined the "data type" as number and "field type" as
Single, "format" as standart and "Decimal Places" as 1. I
entered some data into the table.
When I run SELECT SUM(Q1) FROM....SQL query it returns
values with more than 1 decimal place. How can I get only
1 decimal after summing the numbers?

Thanks a lot for your help

Gerald Stanley · Mar 25, 2004

SELECT Round(Sum(Q1),1) FROM......

Hope This Helps
Gerald Stanley MCSD

Guest · Mar 25, 2004

thanks it is working..

-----Original Message-----
SELECT Round(Sum(Q1),1) FROM......

Hope This Helps
Gerald Stanley MCSD
.

SQL SUM calculation decimal??

ed

Gerald Stanley

Guest