Hi & welcome to Bytes.com.
I agree with Isladogs about there being no context defined in or for your question, and thus it means almost nothing to anyone who doesn't already know what you're talking about (Rick maybe?).
Nevertheless, if we assume that you have two Controls on the same Form where you've got the (unnamed) TextBox with the formula - possibly in the Header Section, then you shouldn't need to specify the Form in your references. Perhaps you could try :
- =Sum(Val(Nz([Text1],0)))+Sum(Val(Nz([Text25],0)))
Certainly, the
Nz()
call would need to be
within the
Val()
one. Otherwise, if any value is Null then it will be fed to the
Val()
function and produce
#Name?
. Giving this to
Nz()
will not fix it in any way of course.
Let us know how you get on. Remember, we only know what you tell us so please tell us clearly.