Nz value

[prudy]

On a balance due report, I get the Nz value of 0 to
appear on all lines. The 0 replaces actual payments.
What is the wording to show that if a payment is made,
show the payment. If no payment is made show a zero.
Can anyone help?

 

[Newbie]

Try
if nz(field,0) <> 0,field,0)