hello
I have a database that keeps track of things that the mileage of changes on a monthly basis each month the mileages are updated unsually about 20 to 30 a month have significant differeneces in mileage. So what I have done to keep track of it and so that the information can be kept correct is that I have created a table that is updated every month with the new mileages and the previous months data is placed in a hist table. I have this working well and it will shows the difference in mileage and allow the people to put the correct information with the correct things.
Well here is the problem what happens if one month there is no check done and it updates automatically and the mileages in the hist folder is then lost and replaced with the previous months mileages.
Is there anyway to possible not allow it to forget the differences in the circuit. Creating almost like a backlog of each months report or something like that or prevent the mileage from updateing until after it has been checked and the mileage updated.
I have a database that keeps track of things that the mileage of changes on a monthly basis each month the mileages are updated unsually about 20 to 30 a month have significant differeneces in mileage. So what I have done to keep track of it and so that the information can be kept correct is that I have created a table that is updated every month with the new mileages and the previous months data is placed in a hist table. I have this working well and it will shows the difference in mileage and allow the people to put the correct information with the correct things.
Well here is the problem what happens if one month there is no check done and it updates automatically and the mileages in the hist folder is then lost and replaced with the previous months mileages.
Is there anyway to possible not allow it to forget the differences in the circuit. Creating almost like a backlog of each months report or something like that or prevent the mileage from updateing until after it has been checked and the mileage updated.