Text Box to Add Fields

[bobbito]

Hi All,



I'm inserting a text box on my report and using an expression to add fields. It seems to work fine except for when one of those fields is blank. Is there something I can add to the expression to force it to calculate even if there is a blank field in the dataset?

Thanks

[ranman256]

use NZ([FIELD])
blanks will become zero.

[bobbito]

It worked, thanks ranman!