Nz value

M

msprudy

On a Balance Due report, I cannot get the report to show
payments made on some invoices and 0 payment made on
others. If C company paid $1000 towards invoice #1 and
$0 toward invoice #2, I can't get the correct wording to
say, if a payment is made, enter the payment, if no
payment is made, enter 0. Can anyone help?
 
B

Bob

What's wrong with using the Nz value as you have already
shown in the subject line of this post?

=Nz([InvoicePayment],0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top