access数据库统计最近12个月（每个月）数据

广告：阿里云采购优惠专区

<%

dim a

' group by month(date)

' 叁照 http://www.cnblogs.com/Fooo/p/3435687.html

sql=" SELECT top 12 cstr(year(actiondate))+'年',cstr(month(actiondate))+'月',count(id),sum(zonger) FROM mvc_order group by year(actiondate),month(actiondate) order by 1 desc"

'最近一月总

totalren=0

totalzonger=0

rs.open sql,conn,1,1

do while not rs.eof

totalren=rs(2)

totalzonger=rs(3)

totalevery=0

totalevery=totalzonger/totalren %>

<tr <%=css%>>

<td><%=rs(0) & " " & rs(1)%></td>

<td></td>

<td></td>

<td></td>

<td><%=Formatnumber(totalren,0,-1)%></td>

<td><%=Formatnumber(totalzonger,2,-1)%></td>

<td></td>

<td></td>

<td><%=Formatnumber(totalevery,2,-1)%></td>

</tr>

<%

rs.movenext

loop

rs.close

set rs=nothing

conn.close

set conn=nothing

%>

广告：阿里云新人采购专场