Sum contents of textboxes

  • Thread starter Thread starter ZBC
  • Start date Start date
Z

ZBC

What is the syntax of and espression to sum the contents of several
textboxes to another textbox on a report?
 
ZBC said:
What is the syntax of and espression to sum the contents of several
textboxes to another textbox on a report?
Click to expand...


=textbox1 + textbox2 + textbox3
 
ZBC said:
Apparently I have a problem involving Nulls ... I'm getting a 0
Click to expand...

Without seeing your expression and the values in the other
text boxes, I can't say what's happening. However, a simple
addition where one of the terms is Null will result in Null.
So, unless you are using a format that displays 0 for null
values, I don't think Null is the issue here.
 
Back
Top