asp+access按年，按月統計數據

　　asp教程+access按年按月統計數據
/*
字段d_id(自動編號) d_je（貨幣型）d_sxrq（日期型）

　　表數據如下

　　d_id   d_je   d_sxrq
           
           
           
           
            
           
           
           
           
          
           
          

　　想按年按月來統計
如果選擇年得到
月份            
金額         

　　如果選擇年得到
月份             
金額           

　　
*/

　　Select Year(D_SXRQ) As Y
       Sum(IIF(Month(D_SXRQ) = D_JE )) As M
       Sum(IIF(Month(D_SXRQ) = D_JE )) As M
       Sum(IIF(Month(D_SXRQ) = D_JE )) As M
       Sum(IIF(Month(D_SXRQ) = D_JE )) As M
       Sum(IIF(Month(D_SXRQ) = D_JE )) As M
       Sum(IIF(Month(D_SXRQ) = D_JE )) As M
       Sum(IIF(Month(D_SXRQ) = D_JE )) As M
       Sum(IIF(Month(D_SXRQ) = D_JE )) As M
       Sum(IIF(Month(D_SXRQ) = D_JE )) As M
       Sum(IIF(Month(D_SXRQ) = D_JE )) As M
       Sum(IIF(Month(D_SXRQ) = D_JE )) As M
       Sum(IIF(Month(D_SXRQ) = D_JE )) As M
From   D_FY
Group  By Year(D_SXRQ);

From:http://tw.wingwit.com/Article/program/net/201311/14430.html