请教SQL查询语句

ACCESS数据库
select top 15 id,title from KS_Product where KS_chandi='进口' and Tid in("&zlmid&") order by ID desc
这句SQL语句如何改成从第15条数据开始取15条？类似mysql里面的limit 15,15
access不支持limit实在太蛋疼了

select top 15 id,title from KS_Product where KS_chandi='进口' and Tid in("&zlmid&") and id<(select top 1 id from (select top 15 id from Product where KS_chandi='进口' and Tid in("&zlmid&") order by id desc) as t1 order by id asc) order by ID desc

这个是降序的取法
如果是升序的取法
把上面的asc换成desc
desc换成asc
id<换成id>

ID必须为不重复的字段。