Compare with last record

[Ardus Petus]

I have an ordered list of Trades, each with a Price.
I would like to compute Price variation from Trade to Trade.
Variation may be positive, negative or zero.

TIA

 

[Allen Browne]

See:
Referring to a Field in the Previous Record or Next Record
at:
http://support.microsoft.com/kb/210504/en-us