How to retrieve rows from position n to position m from table in Access 2003



Hi all

I'm using MS Access 2003 database.
Now I want to write a query that retrieves "n" rows that are not TOP
rows but starts from position "m".
For example: I have a table "Notes". Which has 37 rows and I need to
get rows from 20th to 30th but not need to get TOP 10 rows and last 7
rows.

I tried this:
SELECT TOP 30 * FROM Notes
WHERE [id] NOT IN
(SELECT TOP 20 [id] FROM Notes ORDER BY [id]) ORDER BY [id];

But it results TOP 30 rows without any error.

If I were using MSSQL2000, this query could be fine. But I am using
Access and it doesn't work !

Please post me if you have any idea !

.... Orgil

.