calculating totals for a report 1

[dotolee]

I have a bunch of textboxes that i need to tally up. My problem is that sometimes, the text boxes will be empty.
so far, i have the following code in my "total score" textbox

=CInt([txt1].[Value])+CInt([txt2].[Value])+CInt([txt3].[Value])

what's the best way to also check for a null? if it's null, i don't want to attempt to add it. Right now i get "Error in my total score for any record that has a null

thx

 

[Golom]

Have a look at the NZ function as in

CInt([red]NZ([/red][txt1].[Value][red],"0")[/red]) ...etc.

 

[dotolee]

thanks.
that worked.