ERROR in sql query why?

[luca90]

 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