Very Simple ???... Hopefully

[joecdn]

Can anyone tell me what is the best way to display a certain number of records (up to 10) in a table? Trying to find a syntax for the For ... Loop, but I'm not sure you can do it using a recordset. Anyway, all I want to do is take the first 10 records and leave the rest.

Any insight would be great.
Thanks in advance

 

[amorous]

Try this:

SELECT TOP 10 FROM TableName

Thanks

VJ

 

[Tarwn]

Or you can also use recordset paging if you want to display up to 10 records in a table, per page.

-T

[sub]01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111[/sub]
The never-completed website:

http://www.tiernok.com/