Hi! I try to use Nz function in my report but when I quit and come back to my report, the Nz function has disappeared. I think it's because I don't use it correctly but I don't know how....
I want this calculated field (who is ok)
=[item30]-[paiement30]
return 0 if is null. I tried this
=Nz([item30]-[paiement30],0)
and this
=Nz(([item30]-[paiement30]),0)
but it didn't work
Thanks
I want this calculated field (who is ok)
=[item30]-[paiement30]
return 0 if is null. I tried this
=Nz([item30]-[paiement30],0)
and this
=Nz(([item30]-[paiement30]),0)
but it didn't work
Thanks