Comparing Records Help??

[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?
Thanks!

 

[Jeff Boyce]

Adam

I suspect the folks here can provide a SQL statement that approximates this.

My approach would be to work with queries, create one that gets the most
recent date (using Totals query and "Max"), then create a second query that
finds the maximum date for that person that is NOT in the first query.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP