Iv recently run into a problem with the database I have been creating.
It stems from two user-entered fields, hours paid, and hours worked.
The user enters information at weekend (employee, job number, hours worked, hours paid, pay period end)
the information then gets exported into excel
I need to enter a condition into the hours paid combo box.
It needs to be done in access rather then excel because of the formatting in the excel document.
I need a formula that would do the following
hours paid equals hours worked up until (and including) the 44th hour, every hour beyond that gets multiplied by 1.5
is this possible? any ideas how? and Would I enter that in the "on update" property of the combo box?
Thanks for your time
-SL
It stems from two user-entered fields, hours paid, and hours worked.
The user enters information at weekend (employee, job number, hours worked, hours paid, pay period end)
the information then gets exported into excel
I need to enter a condition into the hours paid combo box.
It needs to be done in access rather then excel because of the formatting in the excel document.
I need a formula that would do the following
hours paid equals hours worked up until (and including) the 44th hour, every hour beyond that gets multiplied by 1.5
is this possible? any ideas how? and Would I enter that in the "on update" property of the combo box?
Thanks for your time
-SL