Adding Two Fields

[m17347047711116]

I have a table that has
[Total Hours Week1]
[Total Hours Week 2]
[Total Payable Hours]

What i would like to do is have the total payable hours calculated automatically when i input [Total Week1] & [Total Week2]


Any Help Appreciated

 

[llkhoutx]

Calculate total hours on the AfterUpdate event. I'd do it after each weekly input, in the event that one of the weeks has no hours. Be sure to use the NZ function on the Weekly hours, in the event one or both are null.

On events Total_Hours_Week_1_AfterUpdate and Total_Hours_Week_1_AfterUpdate, calculate [Total Payable Hours], i.e.

[total Payable Hours] = NZ([Total Hours Week 1]) + NZ([Total Hours Week 2])

Presumably, these are fields on a form.