Reading Value from previous row

[ssecca]

I think I would like to sequentially number the records within a called recordset. The only idea I have is to read the value from the previous record and add one in the current record.

Two questions, are there other, better approachs?

If this is a good approach to this problem, how do I read the previous records value so as to use it in a current record calculation?

Thanks Much

 

[kphu]

Hi there,

I'm having a hard time understanding what your trying to achieve. In the past I have used an array to store my values to do calculations. It all of course depends upon what your planning to do.

Can you clearify?

Ken

 

[ssecca]

I don't like the built in nrecord navigator that access uses. Therefore I want to build my own. My goal is to lat the user know what record thay are currently viewing. To that end I thought I would place a field within the record of the called recordset that sequentalally numbers the records. Then just dispaly that number as the user moves through the chosen sub set of records.

 

[PHV]

And what about the AbsolutePosition property of a RecordsetClone object ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244