Create a report that shows record last date
Hi hope someone can help.
I have created an instrument calibration data base.
I have an instrument entry layout that stores all details of the instrument - this is linked to a result entry layout where the instrument details show and the results of each calibration are entered,along with the calibration date and next calibration date.
I am now trying to create a simple report that will provide a list of the instruments with the next calibration date, this works fine until the instruments are calibrated for a second time and then the report continues to show the old calibration due date.
This is my first database so I may be missing something very obvious but it is driving me mad - please help!