setting a null field to zeros

L

lilbomshl

I am just a beginner to access. I have a currency field that is involved in a
calculation, I have it defaulted to zero, but when it's blanked out my
formula won't work. How can I set the field back to zero if it is blanked
out??
 
O

Ofer Cohen

Use the Nz function in the formula to replace the Null with 0

Nz([FieldName],0)
 
Top