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

[jmcilhinney]

What is this doing?

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?

[jggtz]

Also
Try using 'dbo.CC_Movimenti'

JG