
primero que nada, bienvenido al foro.....
ahora...
intentalo con los parametros "Between"/"And".. de esta forma
Código HTML:
SQL_query = "Select AVG(CU_5) as cu, "&_
"avg(PB_2) as pb, "&_
"avg(ZN_2) as zn, "&_
"avg(AP_2) as ap, "&_
"avg(NI_2) as ni, "&_
"avg(AS_2) as AS_2, "&_
"avg(SN_2) as sn, "&_
"avg(E_USD) as e_usd, "&_
"Fecha FROM I_CELL_DATA "&_
"WHERE Fecha between '" & fechax & "' and '"+fecha2+"' "&_
"GROUP BY Fecha "&_
"ORDER by Fecha", DB2
RS2.Open SQL_query, DB2