--access select avg(BC) as TJ,format(TDate,'yyyy-mm-dd') as SJ from HDataBJ001 where TDate>=#2016-7-8 15:28:23# and TDate <=#2016-9-6 15:28:23# group by format(TDate,'yyyy-mm-dd') order by format(TDate,'yyyy-mm-dd') desc --sql select avg(bc) as bv,CONVERT(varchar(10),area_date,120) as area_date from FJ_KQQXWYS where area_date>='2016-08-27' and area_date <='2016-09-01' group by CONVERT(varchar(10),area_date,120) order by area_date desc