T
Tom
I seem to be having a mental block. Can anyone help with
this problem? I need to keep track of the hours that a
piece of equipment is being used, there is a 'start'
value, which cannot be changed. But I need to add to it
the hours used. I have created a table with the 'start'
value, a table to log when equip. is used and for hours
(sometimes several times in a day.), and a query to sum
the hours used daily. I can calculate the 'total_hours'
for the day. But I can't get a running total to display
in the Log_Entry Form. Ie.. on each daily record I can
total the hours used (total_hours) and add it to
the 'start' value. but when I go to the next record, it
only totals the hours for that record and the start
value, not a running total. I need this so that I know
when to take the equip out of service for maintanence.
Thanks for any help
Tom
this problem? I need to keep track of the hours that a
piece of equipment is being used, there is a 'start'
value, which cannot be changed. But I need to add to it
the hours used. I have created a table with the 'start'
value, a table to log when equip. is used and for hours
(sometimes several times in a day.), and a query to sum
the hours used daily. I can calculate the 'total_hours'
for the day. But I can't get a running total to display
in the Log_Entry Form. Ie.. on each daily record I can
total the hours used (total_hours) and add it to
the 'start' value. but when I go to the next record, it
only totals the hours for that record and the start
value, not a running total. I need this so that I know
when to take the equip out of service for maintanence.
Thanks for any help
Tom