sum on form

[4pbrown]

I have a subform (ECSFinancials) that is embedded in the MasterForm in
Datasheet view. It lists payments made on a file (ECSIndemnity). I want to
tally those payments on my MasterForm and either get the total for all the
files or the most recent payment on a file. If there are no payments on the
file, then I get the #Error message in the box.

Can someone help me? I've read through the previous posts, but none of the
suggestions have worked. I also have a query doing the sum, but I can't pull
that into the form, either.

Thanks!

 

[Jeff L]

In your textbox that is calculating the sum, put
=Nz(Sum(YourFieldName)).

 

[4pbrown]

Thanks for responding so quickly!

Since the Field is in a subform, shouldn't I have to address the name of the
subform somehow?

I did try your recommendation and got an #Error.

Thanks!
-Pat

 

[Jeff L]

Yes. =Nz(Sum(Forms!MasterForm!ECSFinancials!Payments))

If your field is not called Payments on your subform, then substitute
the correct name.

 

[4pbrown]

Oh bummer - I still have an #Error in the field. sigh. Hmmm - any other
thoughts?
Thanks!
-Pat

 

[Jeff L]

Try this:
Put a textbox on the subform and call it SumOfPayments. Change the
visible property to No. Put =Nz(Sum(Payments)) in the text box. On
the main form, put
=Forms!MasterForm!ECSFinancials!SumOfPayments

 

[4pbrown]

Yipppeeeee!! That did the trick!!! Thanks sooooo much!! You're the best!!
-Pat

 

[4pbrown]

How can I get rid of the #Error for the records that have no payment?

 

[Jeff L]

The =Nz(Sum(Payments)) should handle that.

How can I get rid of the #Error for the records that have no payment?