查询的问题
mdbsql = "select top "&Page_size& " * from table where id < (select min (id) from (select top "&(currentPage-1)*Page_size& " id from table order by id desc) as T) order by id desc "
这样能正常显示
问题是当我要用日期排序
即
mdbsql = "select top "&Page_size& " * from table where id < (select min (id) from (select top "&(currentPage-1)*Page_size& " id from table order by date desc) as T) order by date desc "
就会少了很多条结果
不明白为什么
------解决方案--------------------看上去,好像是分页码