以下是引用jspta在2014-2-18 12:11:00的发言：
按jspta指点的方法,得到如下查询表:
此主题相关图片如下：sq.jpg
access上的语句:
SELECT DISTINCTROW Format$(计件明细.完工日期,'mmmm yyyy') AS [完工日期 按月], 计件明细.姓名 AS 姓名之总计, 计件.零件名称 AS 零件名称之总计, 计件明细.工序 AS 工序之总计, 工序表.单价, Sum(计件明细.数量) AS [数量 之 总计], Sum([单价]*[数量]) AS 金额
FROM (计件 LEFT JOIN 计件明细 ON 计件.批次=计件明细.批次) LEFT JOIN 工序表 ON 计件明细.工序码=工序表.工序码
GROUP BY Format$(计件明细.完工日期,'mmmm yyyy'), 计件明细.姓名, 计件.零件名称, 计件明细.工序, 工序表.单价, Year(计件明细.完工日期)*12+DatePart('m',计件明细.完工日期)-1;
参考以上将狐表SQL语句改成:
Select Month(完工日期) AS 月,[姓名],d.[零件名称], b.[工序],sum(数量) as 数量, sum(数量*单价) as 金额 from (select [批次], b.[工序], [数量], c.[单价] from {计件明细} as b inner join {工序表} as c on b.[工序码] = c.[工序码]) as a inner join {计件} as d ON a.[批次] = d.[批次] group by Month(完工日期) , [姓名],d.[零件名称], b.[工序]
结果仍提示:至少一个参数没有指定.
加好友 
发短信
Post By：2014/2/21 9:57:00 [只看该作者]
