D
David Frazell
How can I combine two subsequent records from Table1 into a single record in
Table2?
Table1 has two fields, Unique Record ID and Text String.
For example:
ID Text
1 Text string record 1
2 Text string record 2
3 Text string record 3
4 Text string record 4
....
n Text string record n
n+1 Text string record n+1
The result in Table 2 needs to be:
1 Text string record 1 Text string record 2
2 Text string record 3 Text string record 4
3 Text string record 5 Text string record 6
....
Thanks,
Dave F.
Table2?
Table1 has two fields, Unique Record ID and Text String.
For example:
ID Text
1 Text string record 1
2 Text string record 2
3 Text string record 3
4 Text string record 4
....
n Text string record n
n+1 Text string record n+1
The result in Table 2 needs to be:
1 Text string record 1 Text string record 2
2 Text string record 3 Text string record 4
3 Text string record 5 Text string record 6
....
Thanks,
Dave F.