Calculate between rows

[Guest]

I asked this question some time ago but I since lost the emaila and I cannot
rfind this on the posts anymore.

How do you do calculations between rows?

eg If I had a table with Date and Value such as;
Date Value
01/09/04 30
02/09/04 32
03/09/04 35

How do I compare a record with the one before it. I might want to calc the
diffence from the 3rd to the 2nd which would be 35-32, or I may wish to calc
the change of these 2 days ie (35-32)/32


Bruce

 

[Allen Browne]

See:
Referring to a Field in the Previous Record or Next Record
at:
http://support.microsoft.com/?id=210504