Calculating a sum on a form

[lisagippe]

I can't get a text box to calculate correctly. I have 4 text boxes Sick, Vac, Flt and Other. I need another text box, Reg Hrs, to have this equation in it
=80-sum([Sick]+[Vac]+[Sick]+[Other])

Then another text box that will show the Total Hrs
=[Reg Hrs]+ (Sum([Sick]+[Vac]+[Flt]+[Other])

Any ideas?

 

[fneily]

=80-([Sick]+[Vac]+[Sick]+[Other])
Order of Operations.

=[Reg Hrs]+ ([Sick]+[Vac]+[Flt]+[Other]) Note ) not needed

 

[lisagippe]

You rock! Thank you so much it worked. I figured it was somehting I was doing wrong

 

[Ascentient]

Stupid question, but why are you using the [Sick] field twice?

 

[SilentAiche]

er, forgive the echo, I was also wondering about the [Sick] field being used twice. Is it really Sick1 and Sick2 (or something like that?)

Tim

[blue]______________________________________________________________
I love logging onto Tek-Tips. It's always so exciting to see what the hell I
said yesterday. [/blue]

 

[lisagippe]

Sorry that was a mistype it should have just been [Sick] [Vac] [Flt] [Other]