请问用RS的方法求数据库里某一数值字段的和！

[gengjun83]

我写了一段SQL语句，想用rs的方法求出数据库某一字段的和，而且不能用循环，请问怎么写啊！
帮帮忙啊！谢谢

[lbd8848]

是不是这样
select s=sum(字段) from table

[lbd8848]

set rs=conn.execute(select s=sum(字段) from table)

sumvalue=rs("s")

[lbd8848]

set rs=conn.execute("select s=sum(字段) from table")

[tianjy]

select sum(a) from tbl

[swich]

select sum(字段名) from table

[hrbwzp]

set rs=conn.execute("select sum(字段) as totals from table")
显示求和数值：
rs("totals")