![]() |
#2
cc20062012-12-07 11:01
|
现在结果为全部xf字段的合计,见图,希望的是只统计表格列出的user的xf值!请高手帮忙!
只有本站会员才能查看附件,请 登录
<%
dim rs,conn
Set conn = CreateObject("adodb.Connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("/my.mdb")
set rs=CreateObject("adodb.recordset")
sql="SELECT SUM(xf) AS hj FROM xfgl"
rs.cursorLocation = 3
rs.open sql,conn,1,1
%>
输出:<%=rs("hj")%>分