I have a database where I track the equipment going out for repair and calibration. I have a query of the repair table (Keying in on date) which shows me all the records of repairs ever completed. All equipment has to go back for repair and calibration within an 18 month time period. However I am not sure what the best way to show me only the newest date sent out for each serial number. I have it sorted by date so I basically just need it to show me the newest date for each piece of equipment (serial number) so I can see when the last time the serial number went out.
I have the following fields.
ID, equipment number, Serial number, Sentdate
The example below is for equipment# 5 which is serial number 1234567890.
ID Equip# Serial Sent date
1 5 1234567890 01/01/14
The next time it is sent out.
114 5 1234567890 06/01/16
and again the next time it goes out
223 5 1234567890 11/20/18
I am sorting by date so these would be randomly in the query.
This might be something simple but I am having a hard time figuring it out being new to access. Any help would be greatly appreciated and hopefully this makes sense.