Adding textbox values with blanks

[pctaz]

I can't see to add text boxes if the have blank value

I have a textbox that returns a value from a query for each month.

then I want to total them by quarters and then YTD.
however when I add the textbox or the actual query column if any of the fields are 0 I get a blank return, yet if all the months have a value greater than 0 it works.
here's 1 line of query

Sum(IIf(Month(date)=1,Balance,Null)) AS Jan_Bal, Sum(IIf(Month(date)=1,Settlement,Null)) AS Jan_Set, Count(IIf(Month(Date)=1,Settlement,Null)) AS Jan_Count,

I tried changing the Count(...NULL) NULL to 0 or blank, but then it counts wrong (instead of counting just the settlements in that month it counts them all)

how do I get it to add even if blank or null?

[pctaz]

hmm.. changed the sum iif settlements to return 0 instead of null
seems to be working

[boblarson]

The NZ (Null to Zero) function is normally how you deal with nulls.