Query design

[sabhoir]

I am trying to make a simple access utility to track calibration satus.
I have a tblstatus table with the fields statusID, EquipmentID, DateCalibrated, Status with a linked table tblEquipment.
I would like the report to display only the current record on DateCalibrated.
How do I go about.