Find ONLY latest entry for records, by type and position.

[todmac]

Hello All,


I have a database I want to load tire and brake measurements into. I have created a table which I enter records into, including the date, measurement, the wheel position and the item (tires or brakes) being measured.
On the form I have a picture of a tire and a brake at each wheel position and I would like to be able to display in the control by each item the latest measurement in the main table that matches that wheel position and item.
I have worked hours on this and cannot seem to come up with a solution. Your input would be greatly appreciated, thank you.
Todmac

[RuralGuy]

Latest is one of those relative terms that probably means sort by Date descending and use the 1st record you come to that matches the other criteria.

[rzw0wr]

I would think you need a table for each location. RF,RR,LF, LR and a table for vehicle.

DAle

[todmac]

Thanks.
Got an example of a query that only brings back one record?

[RuralGuy]

If everything is in one table then it looks like 4 separate Me.RecordsetClone.FindFirst statements.