If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sum on form
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! |
#2
|
|||
|
|||
sum on form
In your textbox that is calculating the sum, put
=Nz(Sum(YourFieldName)). 4pbrown wrote: 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! |
#3
|
|||
|
|||
sum on form
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" wrote: In your textbox that is calculating the sum, put =Nz(Sum(YourFieldName)). 4pbrown wrote: 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! |
#4
|
|||
|
|||
sum on form
Yes. =Nz(Sum(Forms!MasterForm!ECSFinancials!Payments))
If your field is not called Payments on your subform, then substitute the correct name. 4pbrown wrote: 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" wrote: In your textbox that is calculating the sum, put =Nz(Sum(YourFieldName)). 4pbrown wrote: 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! |
#5
|
|||
|
|||
sum on form
Oh bummer - I still have an #Error in the field. sigh. Hmmm - any other
thoughts? Thanks! -Pat "Jeff L" wrote: Yes. =Nz(Sum(Forms!MasterForm!ECSFinancials!Payments)) If your field is not called Payments on your subform, then substitute the correct name. 4pbrown wrote: 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" wrote: In your textbox that is calculating the sum, put =Nz(Sum(YourFieldName)). 4pbrown wrote: 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! |
#6
|
|||
|
|||
sum on form
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 wrote: Oh bummer - I still have an #Error in the field. sigh. Hmmm - any other thoughts? Thanks! -Pat "Jeff L" wrote: Yes. =Nz(Sum(Forms!MasterForm!ECSFinancials!Payments)) If your field is not called Payments on your subform, then substitute the correct name. 4pbrown wrote: 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" wrote: In your textbox that is calculating the sum, put =Nz(Sum(YourFieldName)). 4pbrown wrote: 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! |
#7
|
|||
|
|||
sum on form
Yipppeeeee!! That did the trick!!! Thanks sooooo much!! You're the best!!
-Pat "Jeff L" wrote: 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 wrote: Oh bummer - I still have an #Error in the field. sigh. Hmmm - any other thoughts? Thanks! -Pat "Jeff L" wrote: Yes. =Nz(Sum(Forms!MasterForm!ECSFinancials!Payments)) If your field is not called Payments on your subform, then substitute the correct name. 4pbrown wrote: 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" wrote: In your textbox that is calculating the sum, put =Nz(Sum(YourFieldName)). 4pbrown wrote: 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! |
#8
|
|||
|
|||
sum on form
How can I get rid of the #Error for the records that have no payment?
"Jeff L" wrote: 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 wrote: Oh bummer - I still have an #Error in the field. sigh. Hmmm - any other thoughts? Thanks! -Pat "Jeff L" wrote: Yes. =Nz(Sum(Forms!MasterForm!ECSFinancials!Payments)) If your field is not called Payments on your subform, then substitute the correct name. 4pbrown wrote: 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" wrote: In your textbox that is calculating the sum, put =Nz(Sum(YourFieldName)). 4pbrown wrote: 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! |
#9
|
|||
|
|||
sum on form
The =Nz(Sum(Payments)) should handle that.
4pbrown wrote: How can I get rid of the #Error for the records that have no payment? "Jeff L" wrote: 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 wrote: Oh bummer - I still have an #Error in the field. sigh. Hmmm - any other thoughts? Thanks! -Pat "Jeff L" wrote: Yes. =Nz(Sum(Forms!MasterForm!ECSFinancials!Payments)) If your field is not called Payments on your subform, then substitute the correct name. 4pbrown wrote: 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" wrote: In your textbox that is calculating the sum, put =Nz(Sum(YourFieldName)). 4pbrown wrote: 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! |
Thread Tools | |
Display Modes | |
|
|