Algorithm for program maintenance

[Ricardobalbio]

Hello,

I need to develop a query where I put the hour meter machine and know when it's time to perform maintenance. The problem is that if I simply subtract one from the previous hour meter, I did not know if it is necessary to maintain longer periods.



Example: With 210 hours of work I have to do the maintenance of 50, 100 and 200 hours. But with 260 I have to do with only the 50 hours maintenance. And with 310 I have to do the maintenance of 50,100 and 300.

Can anyone help me?Hello,

I need to develop a query where I put the hour meter machine and know when it's time to perform maintenance. The problem is that if I simply subtract one from the previous hour meter, I did not know if it is necessary to maintain longer periods.

Example: With 210 hours of work I have to do the maintenance of 50, 100 and 200 hours. But with 260 I have to do with only the 50 hours maintenance. And with 310 I have to do the maintenance of 50,100 and 300.

Can anyone help me?

[pbaldy]

Is there a reason you duplicated your question?

I have a vehicle maintenance db that probably has similar requirements. I use a "required maintenance" table that would list the vehicle, the type of service, and the interval. I also have a maintenance table where the date, mileage and type of service would be recorded. There is also a vehicle table where the odometer is kept updated through automated processes. From those, I can look up the last service of a given type, get the interval and add it to the last service, compare the result to the current odometer to determine whether or not it's due.

[Ricardobalbio]

Yes, But I need an Algorithm that doesn't need the historical. Because I can't trust in the historical database for my case.

[pbaldy]

How would you know at 310 that the 300 maintenance wasn't done at 300, or 305, or whatever? I don't know how you do it without the history.

[Ricardobalbio]

Actually, I just have the last maintenance.