An overtime program! Help urgently needed!!

[Guest]

I want to write an access program to work out overtime. The concept is that
there are three different pay brackets (£5,£7,£9) .Overtime is paid at time
and a half after 40 hours worked in each bracket. I can get the pay bracket
from the user, and the hours worked using inputboxes. So far I have got the
program to run this information when 40 hours or less is put in but can not
work out the overtime part(when the hours is > than 40 hours)
Any ideas. Thank-you

 

[Guest]

I am kinda new to access but it seems to me if you tried something like

if your value - 40 > 0 then
(value - 40) * 1.5 'for your overtime of times 1.5
else end sub
something like that anyway i'm sure someone else can put that into vb terms
as an example for you