Calculate using a field in current & prev record
Posted on 2000-05-17
Is there an easy way to calculate the difference (movement) between a field value in my current record and the value of the same field in a either the previous or the next record. This should be done with all the records in the table (like a calculated field).
field calculated field
record 12 1090
record 13 1096 6(movement 13-12)