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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to export table from outlook into ms access table? 0
Record insert/delete anomaly 0
Access Dcount (multiple criteria) 3
Copy Previous record 7
Update certain record fields in one table if data exists in anothe 1
VBA - retrieve data on last create named range from previous inserted named range 0
record count of table while looping through all tables 1
Combine records in a table 5

Back
Top