I keep records for about two hundred pieces of equipment. They are tracked by hours. Reports are created every 20 hours. I have created a database that stores the report results using Excel as a frontend.
Once the equipment goes in for overhaul, the previous results are no longer needed. I need to purge these records when they are less than the last overhaul time.
I get an Excel report once a month that has all the last overhaul times.
What would you recommend as the best logic to deal with these records?
I ‘m thinking about looping through the entire database, once a month, using the overhaul times report to delete all the obsolete data.