Hello,

I have a field in my attribute table representing pipe lengths. In an empty field (Distance) I would like to subtract each pipe length from the previous value, thereby calculating the distance. Also, in the field calculator, I need to be able to sort the Pipe_Length field in ascending order before doing the calculation. For example:

Pipe_Length.........Distance

0........................0

1615...................1615

4494...................2879

4630...................136

I have ArcGIS 9.3 and this MUST be done in the field calculator. I have no access to ArcGIS 10 nor can I download an evaluation copy of it. It must be done using 9.3 in the field calculator. The sort ascending must also be done in the field calculator before doing the calculation. Unfortunately I am not able to divert from 9.3 or the field calculator. The result must be exactly how it shows in the above example. My VB logic skills are pretty weak so that it why I am posting here! Thank you for your help!

I have a field in my attribute table representing pipe lengths. In an empty field (Distance) I would like to subtract each pipe length from the previous value, thereby calculating the distance. Also, in the field calculator, I need to be able to sort the Pipe_Length field in ascending order before doing the calculation. For example:

Pipe_Length.........Distance

0........................0

1615...................1615

4494...................2879

4630...................136

I have ArcGIS 9.3 and this MUST be done in the field calculator. I have no access to ArcGIS 10 nor can I download an evaluation copy of it. It must be done using 9.3 in the field calculator. The sort ascending must also be done in the field calculator before doing the calculation. Unfortunately I am not able to divert from 9.3 or the field calculator. The result must be exactly how it shows in the above example. My VB logic skills are pretty weak so that it why I am posting here! Thank you for your help!

Sorry about that -- I forgot to use 9.3 syntax for cursors. Need to go look at the 9.3 help...