How can i limit the number of records to display (like i need 27 records only to display out of 560 records)? I am passing a variable (like 27) from my HTML Screen (Input box).
Exactly how you do it, depends on how you pull back your records, and what database you're using.<BR><BR>Craig.
I am using Access DB. A piece of code helps me a lot. Thanks
SELECT TOP 5 ID, Name FROM MyTable<BR><BR>Look up in the Access Help the "Top" keyword.<BR><BR>Craig.