sqL="select * FROM new  where  lb="&id
  然后怎么让它按时间排序

今天  sqL="select * FROM new  where  lb="&id and 时间字段名 like
'%"&date()&"%'

昨天 sqL="select * FROM new  where  lb="&id and 时间字段名 like '%"&DateAdd("d", -1, date())&"%'

前天 sqL="select * FROM new  where  lb="&id and 时间字段名 like '%"&DateAdd("d", -2, date())&"%'

sqL="select * FROM new  where  lb="&id&" order by times

times是数据库时间字段

sqL="select * FROM new  where  lb="&id&" order by times desc

建议

在表里面再加一个time字段, 保存后．再用SQL语句：sqL="select * FROM new  where  lb="&id&" order by times desc