ERROR in sql query why?

Code:

---

SQL = "TRANSFORM Sum(dbo_CC_Movimenti.Num_Operazioni) AS QUANTITY " & _
          "SELECT dbo_CC_Movimenti.COD_SPORT & [COD_CC] AS INDICE " & _
          "FROM dbo_CC_Movimenti " & _
          "GROUP BY dbo_CC_Movimenti.COD_SPORT &  [COD_CC] " & _
          "PIVOT dbo_CC_Movimenti.COD_CAUSALE_ABI"

---

note:
The table is linked Sql Server table into access database

What is this doing?

Code:

---

SELECT dbo_CC_Movimenti.COD_SPORT & [COD_CC] AS INDICE

---

Is that supposed to be getting two separate columns or concatenating the values of two columns into one string?

Also
Try using 'dbo.CC_Movimenti'

JG