access的数据库 数据截取的问题

我只想截取数据库中指定的部分记录,比如说id从1-10,而我只想截取1-5,或者说6-10.请问如何操作!采用什么语句!谢谢@,以下是获取数据库中所有记录的程序:

Str_Child = ""

Set Rs_Child=Server.CreateObject("adodb.recordset")

Sql_Child = "Select * from WoWo_SrcChild Where Child_TypeID="&Session("_WTypeID")&" and Child_IsUse=true Order By Child_OrderBy"

Rs_Child.Open Sql_Child,conn

if not Rs_Child.eof then

while not Rs_Child.eof

Str_Child = Str_Child & "·<a href='default.asp?Src_Child="&Rs_Child("Child_ID")&"'>" & Rs_Child("Child_Name") & "</a>"

Rs_Child.MoveNext

wend

end if

Rs_Child.Close

Set Rs_Child = Nothing

Select * from WoWo_SrcChild Where id between 1 and 5