S
Stephen.D
Hi,
I need to fill the blank fields with the value of the same field of the
previous record.
For example : 3 fields in the tableA, 4 records.
FIELD1, FIELD2, FIELD3
G5AA,EVA,ABC
<blank>,EVB,<blank>
G5BB,<blank>,<blank>
G5CC,EVC,DEF
Expected result :
G5AA,EVA,ABC
G5AA,EVB,ABC
G5BB,EVB,ABC
G5CC,EVC,DEF
How should I do this? Many thanks.
I need to fill the blank fields with the value of the same field of the
previous record.
For example : 3 fields in the tableA, 4 records.
FIELD1, FIELD2, FIELD3
G5AA,EVA,ABC
<blank>,EVB,<blank>
G5BB,<blank>,<blank>
G5CC,EVC,DEF
Expected result :
G5AA,EVA,ABC
G5AA,EVB,ABC
G5BB,EVB,ABC
G5CC,EVC,DEF
How should I do this? Many thanks.