Solved

Select a particular set of records from MSACCESS table

Posted on 2007-03-26
3
289 Views
Last Modified: 2010-04-25
I have 10 asp pages. I have an MSACCESS table with say some 300 records. I want to select last 10 records ie. rows 290-300 from the table and display it in the first asp page. Then, I want to select the rows 280-290 in the second asp page etc....The number of records in the table are not limited to 300, it keeps growing. I want a select query to take the last 10 records. I have an answer for that,
"select top 10 * from link order by id desc"
This query returns the latest 10 rows from the table, ie. rows 290-300
Now I want to select the rows 280-290. Is there any select query for that. Or can I achieve that is asp coding?

Any hep is appreciated
Thank you.
0
Comment
Question by:CWS (haripriya)
3 Comments
 
LVL 11

Accepted Solution

by:
walkerke earned 250 total points
ID: 18798211
0
 
LVL 9

Expert Comment

by:TheSloath
ID: 18798248
select top 10 * from link WHERE id <= 290 order by id desc
0
 
LVL 8

Expert Comment

by:jawahar_prasad
ID: 18798963
Hi...
I think you need pagination script...

here is a complete solution for your problem...
http://www.aspin.com/home/tutorial/database/display/pagingre
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question