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!

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

"Adam" <(E-Mail Removed)> wrote in message
news:231B8DFD-7508-4E19-A9B9-(E-Mail Removed)...
>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!