Have you got any primary to made the relation between rows?
Maybe... are the calues in column a ordered?
"Kenneth Osenbroch" <kenneth.osenbroch_at_canaldigital.com> wrote in message
news:9c941a28.0209180407.333dcdf6_at_posting.google.com...
> Greetings.
>
> Hopefully, some of you can help me with the following scenario:
>
> Table A : Column A | Column B
> . | .
> Value 4 | Value 5
> Value 6 | Value 7
> Value 8 | Value 9
> . | .
>
> I need to uptdate Table A to become:
>
> Table A : Column A | Column B
> . | Value 4
> Value 4 | Value 6
> Value 6 | Value 8
> Value 8 | .
>
> Ergo, I need to take the value from the the first row and update the
> secound row - 1 with it. Any ideas on how to do this?
>
> Thanks,
> Kenneth
Received on Thu Sep 19 2002 - 09:03:24 CDT
