就一个总计数,还不如用lable显示:
dim artmp as new adodb.recordset
artmp.open "select sum(expr) as aa from table"
if artmp.recordcount>0 then
lable.caption=artmp!aa &""
lable.refresh
endif
set artmp=nothing
dim artmp as new adodb.recordset
artmp.open "select sum(expr) as aa from table"
if artmp.recordcount>0 then
lable.caption=artmp!aa &""
lable.refresh
endif
set artmp=nothing
可以首先绑定Recordset
然后再添加一个总和行。