SQL SUM calculation decimal??

[ed]

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]

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

Hope This Helps
Gerald Stanley MCSD

 

[Guest]

thanks it is working..

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

Hope This Helps
Gerald Stanley MCSD
.