是更新备查表查询设计有误,我给你修改了一下:
更新备查表
修改:
INSERT INTO 备查表明细 ( 日期, 转入货值, 转出货值, 转出支汇, 转出现金, 销售金额, 销售利润, 转入欠单, 备注 )
SELECT DISTINCTROW 月报表.日期,
Sum(nz([月报表!调入货值])+nz([日报表!转入欠单])) AS 转入货值,
Sum(nz([日报表!转出欠单])+nz([日报表!调出货值])) AS 转出货值,
Sum(nz([收当日支票])+nz([收当日电汇])+nz([收欠支票])+nz([收欠电汇])) AS 转出支汇,
Sum(nz([收当日现金])+(nz([收欠现金])+(nz([多交现金])-(nz([少交现金]))))) AS 转出现金,
Sum(月报表.销售金额) AS 销售金额,
Sum(月报表.销售利润) AS 销售利润,
Sum(日报表.转入欠单) AS 转入欠单,
月报表.备注
FROM 日报表 RIGHT JOIN 月报表 ON 日报表.日期 = 月报表.日期
GROUP BY 月报表.日期, 月报表.备注;
原来:
INSERT INTO 备查表明细 ( 日期, 转入货值, 转出货值, 转出支汇, 转出现金, 销售金额, 销售利润, 转入欠单, 备注 )
SELECT DISTINCTROW 月报表.日期,
(nz([月报表!调入货值])+(nz([日报表!转入欠单]))) AS 转入货值,
Sum(nz([日报表!转出欠单])+nz([日报表!调出货值])) AS 转出货值,
Sum(nz([收当日支票])+nz([收当日电汇])+nz([收欠支票])+nz([收欠电汇])) AS 转出支汇,
Sum(nz([收当日现金])+(nz([收欠现金])+(nz([多交现金])-(nz([少交现金]))))) AS 转出现金,
月报表.销售金额,
月报表.销售利润,
日报表.转入欠单,
月报表.备注
FROM 日报表 RIGHT JOIN 月报表 ON 日报表.日期 = 月报表.日期
GROUP BY 月报表.日期, 月报表.销售金额, 月报表.销售利润, 日报表.转入欠单, 月报表.备注, 月报表.调入货值;