I’ve found that applying Nz () correctly can be a bit of a puzzle for some folks. The key is to wrap every field or value in an Nz () function, not the entire expression.

Don't let Null values derail your formulas. See how to use the NZ function to convert the values to zeroes.