字段求和结果放到文本框解决方案

字段求和结果放到文本框
怎样把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