Refer to another row in a table

Hello all,



My problem is as simple as I can't figure it out :)



Basically, I have a table with 6 columns (Field1, Field2...) and a primary key called ID (1,2,3,....).

In the first column (Field1) I want to retrieve the value from the 6th one (Field6) but from the above row. Something like this:



Field1 (ID2) = Field6 (ID1)

Field1 (ID3) = Field6 (ID2)

.......



How can I translate this into a formula?



Thank you!

Refer to another row in a table