I have a field of values 1,2,3,4,....400. I would like to calculate those values into a new field where the value of the SECOND record is 1+2, the third is 2+2, etc, moving in what is basically a diagonal pattern down the list... I know how to do this in excel, but I don't want to take my .dbf out and mess with all that. I know there is a way in field calculator, it's just escaping me right now.
Here is an example of what I'm looking for,
The field LT is already populated, and I want to calculate values into the LF field that are +2 of the value above it. Hope that makes sense?