SELECT Year([销售]![开单时间]) AS 年份, Month([销售]![开单时间]) AS 月份, 销售.企业ID, 明细.原料ID, CInt([明细]![数量]/[产品]![折合立方数]) AS 数量, "折合" AS 进销
FROM 销售 INNER JOIN (产品 INNER JOIN 明细 ON 产品.产品ID = 明细.产品ID) ON 销售.销售ID = 明细.销售ID;
UNION ALL SELECT Year([进材]![日期]) AS 年份, Month([进材]![日期]) AS 月份, 进材.企业ID, 进材.原料ID, [进材]![进材数量] AS 数量, "进材" AS 进销
FROM 进材;
UNION ALL SELECT Year([销售]![开单时间]) AS 年份, Month([销售]![开单时间]) AS 月份, 销售.企业ID, 明细.原料ID, 明细.数量, "产品" AS 进销
FROM 产品 INNER JOIN (销售 INNER JOIN 明细 ON 销售.销售ID = 明细.销售ID) ON 产品.产品ID = 明细.产品ID;