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
I think you have been asked this question a while before..and you are still in problem ??
Anyway.. did you use that LIMIT clause ??
Tell me if you do not know how to use ..
Regrads Tabish Siddiqui
thnx mr. tablish i have used LIMIt with mysql but how can i use limit with ms access and MS sqlserver ??? this is the main point coze LIMIT is not supported in access or sql server. thanks answer this now