我想将查询到的若干条记录中的“用房数量”这一字段求和,代码如下:
dim i as integer
dim roomcount as integer
roomcount=0
for i=1 to rst.recordcount
roomcount=roomcount+datagrid1.columns("用房数量").value
next i
label1.caption=roomcount哪里有错
dim i as integer
dim roomcount as integer
roomcount=0
for i=1 to rst.recordcount
roomcount=roomcount+datagrid1.columns("用房数量").value
next i
label1.caption=roomcount哪里有错
roomcount=0
rst.movefirst
do while not rst.eof
roomcount=roomcount + rst.fields("用房数量")
rst.movenext
loop
label1.caption=roomcount
dim i as integer
dim roomcount as integer
roomcount=0
for i=1 to rst.recordcount
roomcount=roomcount+datagrid1.columns("用房数量").value
next i
label1.caption=roomcount
'''''''''''''''''''''''''''''''''''''''''''''''''
你的datagrid1的当前行没有移动啊,怎么能统计呢?同意二楼的方法。
dim rst7 as Recordset
set rst7 = conn.execute("select sum(用房数量) as rcount form ……" )
roomcount = rst7("rcount")