displaying only x amount of records per page

[axsom1]

How do I display only a certain amount of records? Say for example I query the database and it returns 35 records. I want to be able to say the search returned 35 records, displaying 1-10. Then having a navigation button to let them iterate through the results 10 at a time. I'm familiar with the fields.item method, but dont know how to get the rest working. Any help is appreciated!

Thanks,
John

 

[TonyU]

[tt]Do you use dreamweaver of type your own code?

T ® Ñ ¥
To keep a lamp burning we have to keep puting oil in it.

​

 

[axsom1]

I use Dreamweaver MX and I do type my own code. I have never investigated the built in features. Didn't even think of that. Is there some built in function that will make my life easier??

John

 

[axsom1]

You know what, gosh I feel like an idiot. I see where it is, just have never used the create recordset object in Dreamweaver. Sorry to ask such a silly question when the answer is right in front of me. Thanks again, it must be Friday!!

John