Script to find data from date fields.
I have table MeasurementData with a date field BodyAgeDate. How can I set this up finding data from this field of first date and most recent date. Example: In MeasurementData table I have a field named BodyAgeDate, with another field in it titled Weight. I want to set up a calculation field Beginning Weight and Current Weight where it would take the data from field Weight and populate the Beginning Weight and Current Weight.
BodyAgeDate 7/12/2013; Weight 233 --> This would be Beginning Weight
BodyAgeDate 8/12/2013; Weight 200 ---> If for some reason 7/12/2013 record was deleted or changed to later date, 8/19/2013, then this would be Beginning Weight
BodyAgeDate 8/22/2013; Weight 220
BodyAgeDate 9/2/2013; Weight 190 ---> This is the most current/recent weight
So for Beginning Weight field it would calculate to be 233
Current Weight field it would calculate to be 190