LinkedIn
Twitter
I have created an app to log generator run time. There is a table [generator setup] that has the current total run time for one column and the time since the last oil change in another column. These two columns are used to fill in the previous total hours and oil change hours when entering a log entry and are set up as formulas so they can't be changed within the form. The log section is a separate table called [generator log].
Here is the issue I am having: I want the Previous total hours + Run Time to add into the Total Hours section on the form. This makes it where the user enters the run time and it will automatically give the new total hours. The SUM() functions do not seem to work and wondering how I can get this to work.
Next item: I want to add the Run time to the oil change hours. This might be possible by an action of changing the amount in the original table after submission. I figured I would ask when writing this to see what thoughts yall have.
Thank you for your assistance.
