access中如何实现sql 中的with cube,with rollup
如题.一个access表结构如下:
sales(id,company,count,price,addtime)想统计出一年中每一月份的销售总额和年度销售总额.
select year(addtime) as 年份,month(addtime) as 月份,sum(count*price) as 月份总计 from sales group by year(addtime),month(addtime) 只能统计出每月的,每年的不知道怎么实现,请大家给指点一下,谢谢