Comparing Values between Records

[Adam]

I have a report listing body measurements by date. So i would like to
compare, for example, Body Weight from the most current measurment with Body
Weight from the last measurement and compute the difference then display that
on my report (or use the latest Weight value and compare it to the oldest or
1st Weight value)? Is there a way to do this?

 

[Marshall Barton]

I have a report listing body measurements by date. So i would like to
compare, for example, Body Weight from the most current measurment with Body
Weight from the last measurement and compute the difference then display that
on my report (or use the latest Weight value and compare it to the oldest or
1st Weight value)? Is there a way to do this?

Not easy in a report, but doable in the report's record
source query. Take a look at:
http://allenbrowne.com/subquery-01.html