|
| 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
August 23rd, 2006, 06:13 PM
posted to microsoft.public.access.forms
|
|||
|
|||
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
August 23rd, 2006, 07:39 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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
August 23rd, 2006, 07:50 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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
August 23rd, 2006, 08:33 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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
August 23rd, 2006, 10:03 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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
August 24th, 2006, 03:49 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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
August 24th, 2006, 04:35 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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
August 24th, 2006, 04:43 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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
August 24th, 2006, 05:12 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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 | |
|
|
Linear Mode
