Set rs2=server.CreateObject("adodb.recordset") sql2="select sum(num) AS Total from Date2_1 where typeid="&typeid&"" rs2.open sql2,conn,1,3 和:Total=rs2("Total") num是个表中求和的字段