recurring tasks

[steve111]

HI


I have maintainence database. what I have is a table called machines , one called tasks another for the tasks information and I want to try and automate it more if possible


let says I have a drilling machine , that needs 6 tasks doing to it ,


1. check oil ( daily)
2. check drive belt ( daily)
3 replace belt ( 6 monthly )
4 check chuck ( weekly


I have many machine tools like this with many tasks per machine
is it possible to have a field that I select in my task form either "daily, weekly, 6 monthly , yearly" from a start date
then run a report that shows me what wants doing for the next 7 days.and what has not been done that current day/week
if possible I would like the task to re generate itself so that I can tick it off as being done for that day/week /month . but the next days work is shown albeit the sae task as the day before


thanks
steve

 

[arnelgp]

does any of your table has Date field, task id, and machine id. and a boolean indicating if the task has been done. if you have them, then it would be simple just to query these fields against the current date and query if the boolean field has been ticked. if both fields have been filled, then we can say that the does has been done.

 

[boerbende]

Agree with Arnelgp. You need a start date and have to compare this with the actual date

I have a similar issue with daily shifts (which makes it easier for me, because I print each day a report), so I can use
if(mod(date-startdate),NrOfDays)=0) then ...

For example replace belt -> NrOfDays = 182
Then mod((date-startdate),NrOfDays)=0 at 182 days