大家帮我看看，如何能用access报表功能实现这个电子表格的功能。

点击下载此附件

供参考

SELECT a.区域, Sum(a.数量) AS 当日发运量, (select sum(b.数量) from 基础数据表 as b where b.区域=a.区域 AND Format(b.发运时间,"yyyymm")=Format(a.发运时间,"yyyymm")) AS 全月累计发运
FROM 基础数据表 AS a
GROUP BY a.区域, a.发运时间
HAVING (((a.发运时间)=#1/29/2016#))
ORDER BY a.区域 DESC;