可以这样,我用vb 写一段代码
dim i as interger
if rs.eof the
exit sub
else
rs.movefirst
for i=1 to rs.recordcount-2
输出该条记录
rs.movenext
next
end if
dim i as interger
if rs.eof the
exit sub
else
rs.movefirst
for i=1 to rs.recordcount-2
输出该条记录
rs.movenext
next
end if
rs.movelast
count=rs.absoluteposition '得到总数
rs.moveprevious
if rs.absoluteposition=count then
...
else
...
end if