字段求和结果放到文本框
怎样把ACCESS数据库中某一字段求和,再把结果放到文本框中
[解决办法]
应用ado
dim rst as new adodb.recordset
dim sqlstring as string
sqlstring = "select sum(fieldName) as sum from tablename "
rst.open sqlstring..
txtobj.text =rst.sum
发布时间: 2012-03-12 12:45:33 作者: rapoo
字段求和结果放到文本框
怎样把ACCESS数据库中某一字段求和,再把结果放到文本框中
[解决办法]
应用ado
dim rst as new adodb.recordset
dim sqlstring as string
sqlstring = "select sum(fieldName) as sum from tablename "
rst.open sqlstring..
txtobj.text =rst.sum