Adding Sums in a report

[joe31709]

I have several sums I need to add together to get a total sum of hours in a text box. Only thing is that some of the sums are null(0)and when that happens i only get a blank in total hours.

=Sum([reg hrs])+Sum([ANN)])+Sum([SICK])+Sum([OTHER LEAVE])+Sum([OVER TIME]

What do I need to do..

Thank you
Joe

 

[Rich]

=Sum(Nz(Field1]+[Field2]+[Field3]))

 

[joe31709]

Even if I copy and paste that in there I get an error message. Contains invalid syntax.

 

[Rich]

=Sum(Nz([Field1]+Nz([Field2)) etc