Code to multiply a number

[shariq1989]

When an new overhaul record is entered for a component (ComponentID), I want the overhaul interval (OvhlInterval) for that component to double automatically, so that the application can keep repeating.


Tables:
TblCompletedOverhauls
OvhlID (Pk), ComponentID, DateOvhled


TblComponents
ComponentID, ComponentName, OvhlInterval


What is the best way of doing this?

[pbaldy]

As posted elsewhere:

I would think the interval would remain fixed (x number of miles, hours, etc). In car maintenance applications I store an interval for various items (like oil change). I have a table with maintenance records, where I can find the last time a vehicle had an oil change. I have a table with the current odometer. I can compare the last service and the interval against the current odometer to determine when the vehicle is due for service again.

To do what you're asking wouldn't be difficult. You could run an update query using the ID as a criteria, and double the value. However, I suspect it would only double the first time. In other words, if my oil change interval is 5k miles and I used your method, I'd double it to 10k. However, when it was serviced at 10k I wouldn't want to double it, as that would make it 20k and I want it done every 5k. So, I don't really think your doubling is the way to go.

[shariq1989]

Haha thanks for being omnipresent everywhere... Guess we'll follow the thread on access-programmers!