SELECT语句错误-求助

刘伟生　发表于：2015-11-21 10:50:05 　

这个问题始终无法解决，都没有检查出哪里出现错误了，还请高手给指点下，原文件查询窗体运行就弹出错误：

金宇发表于：2015-11-21 15:36:21

使用下面的语句

Me.子窗体.Form.RecordSource = " SELECT " & strField & " AS 周期," & strFieldqy & " AS 线号区域," & strFieldlb & " AS 类别," & strFieldgw & " AS 发现工位,Sum(defectnum) AS 缺陷数量总计 FROM tb_biq_data" & strWhere & " GROUP BY " & strField & ", " & strFieldqy & ", " & strFieldlb & ", " & strFieldgw & ""

你之前的语句在from之前多了逗号，& strFieldgw 之前少了双引号，结束也需要双引号。

strCaptionlb = "缺陷类型（内部/外部）"
strFieldlb = "defectnw" 没有defectnw这个字段，应该是defectnum

Top

总记录：1篇页次：1/1 9 1 :

Access交流中心

SELECT语句错误-求助