If the data [qty] is blank, want to show 0 in access report instead of blank.
When use below in text box control
=IIf(IsNull([QTY]),0,([QTY]))
It will result in error. Please help to solve this.
Thanks much.
If the data [qty] is blank, want to show 0 in access report instead of blank.
When use below in text box control
=IIf(IsNull([QTY]),0,([QTY]))
It will result in error. Please help to solve this.
Thanks much.
You don't need the if:
nz(field,0)
or use the format property for the control. numbers have 4 states, positive, negative, zero and null, separated by a semi colon, so for nulls to present as 0 your would have
;;;0