Change field in table from previous record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table were I need the information of the record above.
It is a table were de information of two records actually always represent
one record.
But on the second line there is no customernumber anymore. It is blank.
So I need every time the customer number of the record above.
I want to make a loop, to walk through the table and pick-up the value and
put it in the next record.

Does anyone has a solution for this? (except changing the original program
which created this kind of info).

Thanks

Peter
 
Asked and answered all the time. Do a search. That is why records are
retained in a newsgroup.

Rick B
 
Back
Top