查询中的语法不正确

Sergio 发表于 Dev

塞尔吉奥

您好我有这个查询：

strSQL =    "SELECT DATEPART(yyyy,ArriveDate) AS God," & _

"COUNT (CASE  DATEPART(d,ArriveDate) WHEN 1 THEN DATEPART(d,ArriveDate) END)As m1 ," & _
"COUNT (CASE  DATEPART(d,ArriveDate) WHEN 2 THEN DATEPART(d,ArriveDate) END)As m2 ," & _
"COUNT (CASE  DATEPART(d,ArriveDate) WHEN 3 THEN DATEPART(d,ArriveDate) END)As m3 ," & _
"COUNT (CASE  DATEPART(d,ArriveDate) WHEN 4 THEN DATEPART(d,ArriveDate) END)As m4 " & _

 " FROM Company " & _

  " WHERE DATEPART(yyyy,ArriveDate) =" & [Forms]![Raport_lunar_anual_carnete]![ANUL] & _

  " AND DATEPART(mm,ArriveDate)= " & [Forms]![Raport_lunar_anual_carnete]![LUNA] & _

  " GROUP BY DATEPART(yyyy,ArriveDate)"

它说：关键字“ AND”附近的语法不正确

Vignesh Kumar A

尝试这个

strSQL =          " SELECT DATEPART(yyyy,ArriveDate) AS God,"    
strSQL = strSQL & "   COUNT (CASE  DATEPART(d,ArriveDate) WHEN 1 THEN DATEPART(d,ArriveDate) END)As m1 ,"
strSQL = strSQL & "   COUNT (CASE  DATEPART(d,ArriveDate) WHEN 2 THEN DATEPART(d,ArriveDate) END)As m2 ," 
strSQL = strSQL & "   COUNT (CASE  DATEPART(d,ArriveDate) WHEN 3 THEN DATEPART(d,ArriveDate) END)As m3 ," 
strSQL = strSQL & "   COUNT (CASE  DATEPART(d,ArriveDate) WHEN 4 THEN DATEPART(d,ArriveDate) END)As m4 ,"    
strSQL = strSQL & " FROM Company "     
strSQL = strSQL & " WHERE DATEPART(yyyy,ArriveDate) =" & [Forms]![Raport_lunar_anual_carnete]![ANUL] &     
strSQL = strSQL & " AND DATEPART(mm,ArriveDate)= " & [Forms]![Raport_lunar_anual_carnete]![LUNA] &     
strSQL = strSQL & " GROUP BY DATEPART(yyyy,ArriveDate)"

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。