Calculate hours used on a job

[OhOH]

Hello,
I have a Customer table with an 'hours purchased' field. This is the number
of technical support hours they have bought. I also have a 'fault log'
table with the field 'HoursUsed' against that particular fault. I need help
creating a system that will calculate the number of hours each customer has
used and will calculate the remaining hours each customer has left.
Hopefully with an alert when hours reach a certain level. The hours are
deducted per 6 minutes and would need listed to 1 decimal place.
Hope someone can help.
Thanks
KP

 

[Keith W]

Hello,
I have a Customer table with an 'hours purchased' field. This is the
number of technical support hours they have bought. I also have a 'fault
log' table with the field 'HoursUsed' against that particular fault. I
need help creating a system that will calculate the number of hours each
customer has used and will calculate the remaining hours each customer has
left. Hopefully with an alert when hours reach a certain level. The hours
are deducted per 6 minutes and would need listed to 1 decimal place.
Hope someone can help.
Thanks
KP

You can do the calculation in a query easily enough (HoursRemaining =
TotalHours - HoursUsed). The alert could be achieved at form level by
testing HoursRemaining in the form's On Current event:

If Me.txtHoursRemaining < x Then <Do alert stuff>

Pretty high level but you get the idea.

Regards,
Keith.
www.keithwilby.com