I am trying to sum()
I keep getting #err in the page footer and nothing in the report footer
I have records that list and I would like to sum the visible ones (nulls are collapsed).
Some are different fields however they are all currency fields with the correct amounts.
Any unbound box I use doesn't seem to work. I have it working fine on another form without canshrink and I am wondering if that is what it is...
I have tried using =Sum(Nz([txtPaymentDeposit],0)+Nz([txtPayment1],0)+Nz([txtPayment2],0)) with no luck