如何查询统计一段时间内的原材料耗用情况

[peaceyan]

我用VB+MS SQL编写了一段查询语句，如果只通过查询产品型号可以统计
SELECT prdu_xh, part_xh, sqno, part_typ, SUM(part_num) AS part_num
FROM dbo.cpgcmx_SC
GROUP BY part_xh, sqno, part_typ, prdu_xh
HAVING (prdu_xh = 'gkb31/1')
其中，prdu-xh表示产品型号，part-xh表示原材料编号，part-num表示原材料数量

如要实现一段时间查询该如何写？我用的是DTPicker控制

[饮水需思源]

select * from talbename where 日期字段 between '2003-10-1' and '2003-10-29'

[飘零风]

在from后加入where 子句就可以了啊。另外，那个having让我觉得有点迷惑：应该也可以写进where子句的吧？

[射天狼]

"select * from tablename where datefield between '" & dtpicker1.value & "' and '" & dtpicker2.value & "'"

[peaceyan]

having 和where是不能同时用的，报错incorrect syntax near the keyword 'where'

[飘零风]

谁说having和where不能同时用？肯定是你写错地方啦。where 子句要放在 from 子句的后面、group by 子句的前边。

[peaceyan]

OK,TKS