Page 1 of 1

Retrieve record from Access DB

Posted: Tue Oct 14, 2003 2:20 am
by desmondlk
Hi All,

May I know how to retrieve record from Access database by limiting the number of records being return?

For example, if the table has 30 records and I decided to retrieve 20 records starting from the first. How can do this in Access by using SQL statement?

Thanks in advance.

Desmond.

Posted: Tue Oct 14, 2003 3:43 am
by JAM
http://www.phpfreaks.com/tutorials/61/0.php

"select top 20 * from table" i guess would be a good start dealing with the select-clause retrieving 20 of 30 rows.