sta query mi manda al manicomio...

SQL = "select SUM (numero) as totale from storico"

recupero con : <%RECDown("totale")%>

e va in errore...
posto il code completo...

<%
Dim ConnDown
Set ConnDown=Server.CreateObject("ADODB.Connection")
ConnDown.Open "driver={Microsoft Access Driver (*.mdb)};dbq="& server.MapPath(path&"/database/db.mdb")
Dim SQLDown,RECDown,SQL

SQLDown = "select * from tbl where data >= #"&request.form("data1")& "# and data <= #"&request.form("data2")& "# order by numero desc"

SQL = "select SUM (numero) as totale from tbl"

Set RECDown= server.CreateObject("ADODB.Recordset")

RECDown.Open SQLDown,ConnDown,1,3

dim numRecords
numRecords = RECDown.RecordCount

if RECDown.eof then
response.write "Nel periodo selezionato non risultano record"
else
While Not RECDown.EOF
%>

Hai provato a utilizzare un cursore lato client?
Difficilmente la proprietà recordcount funzionerà altrimenti.

gino

cmq va in errore:

scrivendo così:

SQL = "select SUM (numero) as totale from tbl"
Set RECDown=ConnDown.Execute(SQL)

dim numRecords
numRecords = RECDown.RecordCount

if RECDown.eof then
response.write "Nessun record restituito"
else
While Not RECDown.EOF

SQLDown = "select * from tbl where data >= #"&request.form("data1")& "# and data <= #"&request.form("data2")& "# order by data desc "
Set RECDown=ConnDown.Execute(SQLDown)

restituisce:

ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
somma.asp, line 87 = <%=RECDown("totale")%>

----------------------------------

scrivendo invece così:

SQL = "select SUM (numero) as totale from tbl"
Set RECDown=ConnDown.Execute(SQL)

dim numRecords
numRecords = RECDown.RecordCount

if RECDown.eof then
response.write "Nessun record restituito"
else
While Not RECDown.EOF

SQLDown = "select * from tbl where data >= #"&request.form("data1")& "# and data <= #"&request.form("data2")& "# order by data desc "
Set RECDown=ConnDown.Execute(SQLDown)

Restituisce:

ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/somma, line 62 = RECDown.Open SQLDown,ConnDown,1,3


dov'è l'errore????

il campo nuemro è numerico;
utilizzo ms access 2002
facendo la prova che suggerisci restituisce:

ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/somma.asp, line 62

line 62:
RECDown.Open SQLDown,ConnDown,1,3