Dim pageCount As Integer '记录总页数Dim nowPage As Integer '记录当前页先得到总页数,每页20条数据的话总页数就是 pagecount=rs.count/20上一页nowPage=nowPage-1下一页nowPage=nowPage+1做下是否到达最首页和最末页的判断...if nowpage=pagecount,自已做下处理查询语法="selecttop 20 * from 报警记录where报警id not in (select top " & nowPage*20 & " 报警id from 报警记录 where报警名