how can divide

[Anon]

hi ...
how can i split my query results into different pages . it is possible in mysql but how can i use it with Access and sql server. ???
i mean to say i don't want to use where clause... or suppose that i m using where clause i.e where id < 10 but suppose this generates 200 results that has ID less than 10 then how can i divide my 200 results into 50 records each page ???
thanks
shahid

[Anon]

hi ...
how can i split my query results into different pages . it is possible in mysql but how can i use it with Access and sql server. ???
i mean to say i don't want to use where clause... or suppose that i m using where clause i.e where id < 10 but suppose this generates 200 results that has ID less than 10 then how can i divide my 200 results into 50 records each page ???
thanks
shahid

[Anon]

use LIMIT