How to move to the next record? 
Author Message
 How to move to the next record?

We have a function in ADO called MoveNext which moves to the next record in
the recordset. Say I want to do the same in CR, how?

The Next() function used in formulae shows only the consecutive next record.
I want to access 2 and 3 more records after the immediate next one.
How can i do it?

Example:
We have the following data table for the report to display

Row #1
CompanyCode: 1000233000
FinancialYear: 199501
Data1: 45697
Data2: 89744

Row #2
CompanyCode: 1000233000
FinancialYear: 199601
Data1: 49897
Data2: 12744

Row#3
CompanyCode: 1000233000
FinancialYear: 199701
Data1: 89697
Data2: 89444

Row#4
CompanyCode: 1000233000
FinancialYear: 199801
Data1: 12397
Data2: 45644

With the Next() function i can get values in Row#2, but how to access values
from Row#3 or Row#4?

Any help is highly appreciated.

Zoaib



Sun, 16 Dec 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. How to move to the next record?

2. Disable move to prev/next record when turning mouse wheel

3. How to move to the next record

4. Disconnected Recordset will not move to the next record

5. How to make combo box move to next record

6. Doing Error Checking before moving to next record

7. Move next takes user to new record - not wanted

8. Move Next Record

9. Data control will not refresh/move to next record

10. Move to next record in DAO

11. Move Next or move previous

12. Enter,Next Row and Clear for Next record

 

 
Powered by phpBB® Forum Software