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



"Peter Adema" <(E-Mail Removed)> wrote in message
news:4D4AE225-4D24-4E28-9441-(E-Mail Removed)...
> 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
>