高分求教：统计某数据表中一个字段值的合计！！

[aiaiai]

有一数据表，想把其中某字段的合计值赋给一变量，如何用SQL语句实现？？？

[zqfleaf]

select sum(field) from table

[cqq_chen]

dim cn as ado.con....
dim d as ado.recoreset
dim strsql as string

cn.open ...
strsql="select sum(fieldname) from tablename"
d.opcn strsql,cn
debug.print d.fields(0)

[dxqylzg]

dim tmp as string
dim cn as ado.con....
dim d as ado.recoreset
dim strsql as string

cn.open ...
strsql="select sum(fieldname) from tablename"
d.opcn strsql,cn
tmp=d.fields(0)

[txlicenhe]

dim rs as ado.recoreset
dim strsql as string

strsql="select sum(fieldname) from tablename"
rs.opcn strsql
变量=rs.fields(0)

[hansblue]

dim conn As ado.con....
dim rst As ado.recoreset
dim txtSQL as string

cn.open ...
txtSQL="select sum(fieldname) as Myfield from tablename"
rst.opcn strsql,cn
rst.Fields("Myfield") '你要求的统计值.