Beerbrewer
Registered User.
- Local time
- Today, 05:45
- Joined
- Jul 18, 2002
- Messages
- 22
I have made a linked table to a text file (which is continuously updated). Unfortunately the file is formatted as report. This means that the first values are omitted if they are double. For a proper processing I must put those values "back". So far I know there is no solution by SQL since if the first value of a record Is Null, its value depends on the first (not empty) value of a record above (in the same table).
I would like to let VBA loop trough the table. When it encounters a Null-value it should add the value of the above record.
It looks like this:
1 <Record1>
<Record2>
2 <Record3>
3 <Record4>
<Record5>
<Record6>
4 <Record7>
etc.
It should look like this:
1 <Record1>
1 <Record2>
2 <Record3>
3 <Record4>
3 <Record5>
3 <Record6>
4 <Record7>
etc.
Is there a SOLUTION?
Many thanks!
I would like to let VBA loop trough the table. When it encounters a Null-value it should add the value of the above record.
It looks like this:
1 <Record1>
<Record2>
2 <Record3>
3 <Record4>
<Record5>
<Record6>
4 <Record7>
etc.
It should look like this:
1 <Record1>
1 <Record2>
2 <Record3>
3 <Record4>
3 <Record5>
3 <Record6>
4 <Record7>
etc.
Is there a SOLUTION?
Many thanks!