Nz value

  • Thread starter Thread starter msprudy
  • Start date Start date
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?
 
What's wrong with using the Nz value as you have already
shown in the subject line of this post?

=Nz([InvoicePayment],0)
 
Back
Top