Add on to formula

M

Michelle

Is it possible to add on to this formula to state that if no value to enter 0?
=DSum("[CrGiBgChecked]","[1 deskiewicz]")
 
M

Marshall Barton

Michelle said:
Is it possible to add on to this formula to state that if no value to enter 0?
=DSum("[CrGiBgChecked]","[1 deskiewicz]")
Click to expand...


=Nz(DSum("[CrGiBgChecked]","[1 deskiewicz]"), 0)
 
Top