looking for only the most recent measurements

[todmac]

Hello,
I have a database I have created that stores measurements of different components in operation. We measure on a regular basis and store each record showing the unit#, date, mileage, item being measured, measurement.
I want to be able to set a criteria (minimum measurement) and pull all the records that meet that criteria. Except, I only want it to look at the most recent measurements. So it should only be looking at the most recent measurements and then pulling them if they are below the minimum measurement.



Any thoughts on how to best accomplish this?
Thanks,
todmac

[June7]

Review this, poster had similar requirement. https://www.accessforums.net/reports...tax-38123.html