IF Then calculation

[Jon123]

Trying to calculate a few fields. 1st field is [delays] and 2nd field is [Planned]
The Plan scheduled for 60 and the Delays are an entered value. In the on update command button on the form I want code that will take the value above 60 and add then to the value in the [Delays] So if delays is 10 and the planned is 70 then planned will change to 60 and delays will = 20

any help

Jon

 

[KenHigg]

Say it again. It isn't making sense...

 

[yhgtbfk]

Not sure entirely what you mean, but this may help.

myValue = planned + delayed

If myValue >= 60 then
planned = 60
delayed = myvalue - 60
Else
planned = myvalue
delayed = 0
End If