ASP中sum函數語法?
完整篇: Set conn=Server.CreateObject('ADODB.Connection') conn.Open 'Driver={Microsoft Access Driver (*.mdb)};DBQ='&Server.MapPath('ab.mdb') SQL='SELECT sum(分值) as zong FROM 表 where 月份=' & yue &' ' 求滿足此月份的字段分值的總和
Set rs=conn.Execute(SQL) 用時: response.write rs1('zong')