请教高手一个应该算简单的问题!

[shenxiaozhe]

我想在查询语句从数据库中查完所有数据后，直接返回一个所有数据的总和（当然，数据都是数字），不知道该用哪条SQL语句，哪位仁兄可以助小弟一把！不胜感激！*^O^*

[wei1027]

select sum(num) from table where 条件

[strongfisher]

select sum(num) from table where 条件

[shenxiaozhe]

在VB中编译有错误！！郁闷！

[馮強]

贴出你的代码，你在VB中怎样执行SQL的?

[strongfisher]

select sum(num) as numtatol from table where 条件

dim i as double
i=rs.fields("numtatol ").value

[Alicky]

代码看一下。

[shenxiaozhe]

稍等

[shenxiaozhe]

Set Rs = Conn.Execute(" select sum(费用合计) from 某用户的费用 where 收费年份= " & y & " and 收费月份= " & m & " and state='1' ")

[LCAAA]

Conn.Execute(" select sum(费用合计) from 某用户的费用 where 收费年份= " & y & " and 收费月份= " & m & " and state='1' ")
是不是应该直接这样写呀。

[shenxiaozhe]

不行，照样报错！

[饮水需思源]

if rs.state=adstateopen then rs.close
rs.open " select sum(费用合计) from 某用户的费用 where 收费年份= " & y & " and 收费月份= " & m & " and state='1' ",conn,adopenkeyset,adlockreadonly