|
-
Sep 27th, 2000, 04:49 PM
#4
I can think of one way.
Bookmarks simply mark a record so that you could go back quickly. If you sort the Potential with no book mark to start, you will get the first 10 records from FirstTen.
Retrieve the LAST sort value from FirstTen. Now re-write FirstTen to reflect the >= value in Potential.
........code sequence from above
sql = "Select * from Potential where srtvalue>="
sql = sql & chr$(34) & lastvaluefromten & chr$(34)
sql = sql & ";"
dbs.querydefs.delete("FirstTen")
dbs.querydefs.refresh
dbs.createquerydefs("FirstTen",sql)
........code sequence continues
Good Luck
DerFarm
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|