sqltext="select w_name as t1,sum(w_sale) as 金额,sum(w_shulian) as t3 from weiya01 where w_date like '%"& request("name1") &"%' group by w_name order by 金额 desc "

这样就报错:

Script error detected at line 14.
Source line: rs.open sqltext,conn,1,1
Description: ODBC 驱动程序不支持所需的属性。

不加order by 金额 desc 就没事