G
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
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