Re: How to retrieve rows from position n to position m from table in Access 2003
- From: "'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 31 Aug 2007 14:26:53 GMT
Hi, Orgil.
Here is another way to display rows #21 through #30, and it will run faster
than my earlier suggestion. That may not be noticeable with a small data
set, but with a large one, efficiency counts.
SELECT TOP 10 R1.*
FROM Notes AS R1 LEFT JOIN
(SELECT TOP 20 *
FROM Notes
ORDER BY ID) AS R2 ON R1.ID = R2.ID
WHERE (ISNULL(R2.Stuff))
ORDER BY R1.ID;
.. . . where Stuff is the name of a column in the Notes table.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
.
- References:
- Prev by Date: Re: Timestamps
- Next by Date: mailmerge
- Previous by thread: Re: How to retrieve rows from position n to position m from table in Access 2003
- Next by thread: Inner Join question!
- Index(es):
Relevant Pages
|
