Re: Update table.

Kenneth Osenbroch wrote:

> kenneth.osenbroch_at_canaldigital.com (Kenneth Osenbroch) 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
>
> Thanks for the reply guys.
>
> I think I need to clarify the mentioned scenario a litle further. The
> thing is that each record in Column A consists of a character (one
> single character), and therefor it can't be unique (sorry to have left
> out this information in my first posting).
>
> So, what I need is to fetch the value from ex. record 3 in row 1 to
> record 2 in row 2. I think it will be the same scenario as mentioned
> earlier, bur without the possibility to substract a numeric value.
>
> Is this possible?
>
> Thanks,
> Kenneth

I've no doubt you know what you are trying to communicate. But your posting is so confusing I have no idea what you are trying to accomplish.

Daniel Morgan Received on Thu Sep 19 2002 - 10:13:12 CDT