Grouping Records on continuous forms

[Matt Kisasonak]

Is it possible to return only the first ten records and
have buttons to go to the next ten and so on? The same
way web pages work.

 

[Michel Walsh]

Hi,


- Rank the records, then use the appropriate criteria like: WHERE rank BETWEEN 11 AND 20

or

- SELECT TOP 10 ... FROM (SELECT TOP 20 .... ORDER BY f1 ASC) .... ORDER BY f1 DESC

or open a read only forward only recordset and pump back the 10 next records, one record at a time
inside a loop (may be the faster solution for very large tables).



Hoping it may help,
Vanderghast, Access MVP