How to show most recent measurement for each wheel position

[todmac]

Hello everyone,
I am building a database that records the measurements of tire tread on many vehicles (each vehicles has many wheels).
I have built my tables and relationships and entered measurements. So for each unit I have multiple wheel positions with a measurement for each.

In my form I want to display the newest measurement for each position (10 positions in all). I cannot figure out how to do this. I tried building a little query for each position and then displaying it on the form, but that doesn't seem to work.


Any help or guidance please and thanks?
Todmac

[pbaldy]

Does this concept work for you?

http://www.baldyweb.com/LastValue.htm