How do I make blank fields in forms count as zero in Access?

R

ricker alford

In a form I am trying to multiplly and add numbers but I do not want the
zeros to show and I want blank spaces to act as zero so that expressions will
show totals if some fields are left blank.
 
W

Wayne Morgan

Use the Nz() function around each field name in the equation.

Example:
Nz([Field1], 0) + Nz([Field2], 0)

This will replace a Null value with 0.
 
Top