zhc19620430 发表于 2011-9-26 17:23
就是行日期显示累计问题。
参考:{:soso__14050309461632682842_4:}
- SELECT 日期,产品,数量,数量累计 FROM
- (
- SELECT MONTH(日期) AS 排序,日期,产品,数量,DSUM("数量","数据$","日期&产品<='"&日期&产品&"'") AS 数量累计 FROM [数据$]
- UNION ALL
- SELECT DISTINCT MONTH(日期)+0.1,MONTH(日期)&"月合计",NULL,DSUM("数量","数据$","MONTH(日期)="&MONTH(日期)&""),DSUM("数量","数据$","MONTH(日期)<="&MONTH(日期)&"") FROM [数据$]
- UNION ALL
- select DISTINCT FORMAT(日期,"q")*3+0.2,FORMAT(日期,"第q季度合计"),NULL,DSUM("数量","数据$","FORMAT(日期,'q')="&FORMAT(日期,'q')&""),DSUM("数量","数据$","FORMAT(日期,'q')<="&FORMAT(日期,'q')&"") FROM [数据$]
- UNION ALL
- SELECT DISTINCT YEAR(日期),YEAR(日期)&"年合计",NULL,DSUM("数量","数据$","YEAR(日期)="&YEAR(日期)&""),DSUM("数量","数据$","YEAR(日期)<="&YEAR(日期)&"") FROM [数据$]
- )
- ORDER BY 排序,日期,产品
复制代码
|