Grouping Records on continuous forms

  • Thread starter Thread starter Matt Kisasonak
  • Start date Start date
M

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.
 
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
 
Back
Top