Return 0 if field is Null

[Tcurtis]

I have a query that returns a Null value if it is empty. I want the field to have a zero in it if it is null. Can I use the Criteria field to write an expression to create that?
I need the field to be 0 if it is empty. I have tried IIf(IsNull([Current Month]),0) But that makes my query return the entire query blank. I tried this in the criteria of the query but it does not work. How can I make this field return a 0 if it is blank or null.

Thanks

 

[Joe4]

You want the NZ function. See: MS Access: Nz Function

 

[Tcurtis]

Trend: Nz([Current Month])-Nz([Previous Month])

Works like a charm. Thanks!!