help with calculated fields!
hello to all! hope someone can give some time for this....my problem looks this way, i have 4 fields...that is hours, %split-hours, excess, %split-excess...with total per each field under them...what i want is if the user enter a value in the hour field....the value of %split-hours will depend on it...the same way as with excess....so i put reghour/totalreghour in the controlsource of reghour.....so the result is fine....but i want the result of total %split-hour always be equal to 100.....how can i possibly do that? thanks for any help! =)