title: Invalid SQL statement; expected "DELETE"
body: <p>I have the following code in MS Access:</p>
  
  <pre><code>Set rs = con.Execute
  
  (SELECT PO_Number, PR_Number, PO_Creator_Number, PO_Creator_Name, PR_Creator_Number, PR_Creator_Name, 
     (CASE WHEN PO_Creator_Region &lt;&gt; "'IL'"
     THEN
     ((DATEDIFF(dd, PR_Creation_Date, PR_Approval_Date)+1)
    -(DATEDIFF(wk, PR_Creation_Date, PR_Approval_Date)*2)
    -(CASE WHEN DATENAME(dw, PR_Creation_Date) = "'Sunday'" THEN 1 ELSE 0 END)
    -(CASE WHEN DATENAME(dw, PR_Approval_Date) = "'Saturday'" THEN 1 ELSE 0 END)),
                      ELSE
                       ((DATEDIFF(dd, PR_Creation_Date, PR_Approval_Date)+1)
                      -(DATEDIFF(wk, PR_Creation_Date, PR_Approval_Date)*2)
                      -(CASE WHEN DATENAME(dw, PR_Creation_Date) = "'Friday'" THEN 1 ELSE 0 END)
                      -(CASE WHEN DATENAME(dw, PR_Approval_Date) = "'Saturday'" THEN 1 ELSE 0 END))
                      END) AS PR_Cycle_Time  
  
  FROM PO_PR_INFO_TBL
  
  WHERE PR_Creation_Date ='" &amp; txtnumb &amp; "'",
           PR_Approval_Date = '" &amp; txtnumb &amp; "'",
           PO_Creation_Date ='" &amp; txtnumb &amp; "'"
  
  GROUP BY PO_Number, PR_Number, PO_Creator_Number, PO_Creator_Name,   PR_Creator_Number, PR_Creator_Name)
  </code></pre>
  
  <p>Then MS Access gives me an error message saying </p>
  
  <blockquote>
    <p>Invalid SQL Statement; expected "DELETE", "INSERT", "PROCEDURE",
    "SELECT", or "UPDATE"</p>
  </blockquote>
  
  <p>Can anyone help me on solving this issue?</p>