Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'scarico' as part of an aggregate function.

/ruote/elenco_prodotti.asp, line 48


codice:
SQLsc="select idprodotto, scarico, sum(pre_vendita*scarico) as fatturato, sum(pre_acquisto*scarico) as spese"
SQLsc=SQLsc & " from "
SQLsc=SQLsc & "(select * from Scarico where data_scarico>=#" & dataDal & "# and data_scarico<=#" & dataAl & "#)"
SQLsc=SQLsc & " group by idprodotto order by idprodotto asc"

set RS=Conn.execute(SQLsc)
cosa sbaglio?