I had this in the MS Office forum, and got my answer to do this excel. But, now I have some files with too many records for Excel. Can this be done in Access?
An example will explain what i need to do best. This is what I have:
Field 1 Field2
100
102
101
103
---100--- ---100---
201
203
205
200
---200--- ---200---
I was able to move over the ---100--- and so on to another field. I'd like to fill everything blank above the number with the next piece of data, so I wind up with:
Field 1 Field2
100 ---100---
102 ---100---
101 ---100---
103 ---100---
---100--- ---100---
201 ---200---
203 ---200---
205 ---200---
200 ---200---
---200--- ---200---
Is this possible?
An example will explain what i need to do best. This is what I have:
Field 1 Field2
100
102
101
103
---100--- ---100---
201
203
205
200
---200--- ---200---
I was able to move over the ---100--- and so on to another field. I'd like to fill everything blank above the number with the next piece of data, so I wind up with:
Field 1 Field2
100 ---100---
102 ---100---
101 ---100---
103 ---100---
---100--- ---100---
201 ---200---
203 ---200---
205 ---200---
200 ---200---
---200--- ---200---
Is this possible?
