nz function

Bioman

Registered User.
Local time
Today, 13:17
Joined
Feb 28, 2002
Messages
29
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
 
It work great! Thank you!
 

Users who are viewing this thread

Back
Top Bottom