Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to copy data from header field to next records
Cheers, very impressed with speed of response. What an excellent forum! I'll try the code on Tuesday and let you know how it goes. [smile]- caroeliz
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
How to copy data from header field to next records
I have a table with 10M+ records - only 3 fields: counter, date, id 1 01/01/05 1234567 2 01/02/05 3 01/01/04 4 01/01/05 2345678 5 12/12/03 3333333 6 13/12/03 7 01/01/02 etc I need to copy id to the next record until id is not null and next id is null to repeat the process: 1 01/01/05...- caroeliz
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
