errore: You tried to execute a query that does not include the specified expression

[Lino80]

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

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?

[wallrider]

response.write(SQLsc)

[Lino80]

select idprodotto, scarico, sum(pre_vendita*scarico) as fatturato, sum(pre_acquisto*scarico) as spese from (select * from Scarico where data_scarico>=#2007-9-1# and data_scarico<=#2007-10-1#) group by idprodotto order by idprodotto asc

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

[optime]

il messaggio è chiaro. devi mettere 'scarico' nella group by, oppure toglierlo dalla select

[Lino80]

grazie

[optime]

prego