#SIZE! What am I doing wrong? (NZ function)

[Gina Maylone]

Good morning all,

I am simply trying to print a customer statement, and when there are no payments against an invoice I get #size! in the calculated balance due field. I have this in the payments subreport footer: =Sum(Nz([PaymentAmount],0)) and then again on the statement report footer I have: =[invoicedetails].[Report]![invtotal]-Nz([Payments].[Report]![TotalPayments],0). I've tried searching for the #size! error and have found nothing useful.

Thank you in advance.


Gina

[Gina Maylone]

I got it. Never had this problem before and never saw this function before. Learn something new everyday I guess.

Function nnz(testvalue As Variant) As Variant
'Not Numeric return zero
    If Not (IsNumeric(testvalue)) Then
        nnz = 0
    Else
        nnz = testvalue
    End If
End Function

[pbaldy]

More info here:

http://access.mvps.org/access/forms/frm0022.htm

[Gina Maylone]

Yup! That's where I got it - found the link from one of your old posts Paul! Thanks! Have a great day!

[pbaldy]

You too Gina!