ACCESS 按月统计

来源：百度知道 编辑：UC知道 时间：2024/05/31 22:15:44
ACCESS 数据库中怎么样查询一个月中每天的总金额啊？？
像这样显示

月份 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9| 10|11|12
金额 30.5| 21 | 12 | ..剩下的略。。。

这样怎么样实现啊 ？？？望高手请教！，我前几天提问都没分了，就这20分了 ，不要嫌弃。
呵呵 我研究出来了，，，，

Select Year(InDate) As 年份,
Sum(IIF(Month(InDate) = 1, TotalMoney, 0)) As 1月,
Sum(IIF(Month(InDate) = 2, TotalMoney, 0)) As 2月,
Sum(IIF(Month(InDate) = 3, TotalMoney, 0)) As 3月,
Sum(IIF(Month(InDate) = 4, TotalMoney, 0)) As 4月,
Sum(IIF(Month(InDate) = 5, TotalMoney, 0)) As 5月,
Sum(IIF(Month(InDate) = 6, TotalMoney, 0)) As 6月,
Sum(IIF(Month(InDate) = 7, TotalMoney, 0)) As 7月,
Sum(IIF(Month(InDate) = 8, TotalMoney, 0)) As 8月,
Sum(IIF(Month(InDate) = 9, TotalMoney, 0)) As 9月,
Sum(IIF(Month(InDate) = 10, TotalMoney, 0)) As 10月,
Sum(IIF(Month(InDate) = 11, TotalMoney, 0)) As 11月,
Sum(IIF(Month(InDate) = 12, TotalMoney, 0)) As 12月
From t_InStorageNO where Year(InDate) ='2010'
Group By Year(InDate);

请提供表结构