strsql ="SELECT sum(unit_price), search_name,producto,descripcion, nro_orden_compra, job_number, inv_no, fecha_req_desde, shipped_dt, cantidad, qty_to_ship, peso_placa, ton, unit_price, vtaus, ctous, pvtaus, ctomt, dpc
FROM VDespachos_Con_DPC WHERE (shipped_dt BETWEEN '"&fecha_desde&"' AND '"&fecha_hasta&"') AND (slspsn_no = '"&asistente&"')
ORDER BY search_name, nro_orden_compra, job_number GROUP BY shipped_dt"
me da este error
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Sintaxis incorrecta cerca de la palabra clave 'GROUP'.
/reporte_vdespachos_con_dpc.asp, line 43