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
|
|||
|
|||
Total Detail on Continuous Form
I have a form based on one table and a subform based on another table. They
are linked on a common identifier. The subform is setup as a continuous form. The main form contains repair order information, including the repair rates. The subform contains the actual repair information (description / body hours / refinish hours / etc). I have hidden fields doing calculations in each line (calculating part price with discount / rate from main form * hours in subform / and a line total). All of this is working great! Now I need to total down for a total cost of repairs. I have gone into my subform and inserted a text box into my form footer with the following information in the Control Source: =sum([linetotal]) but when I view the form in Form View, all I get is: #Error Any suggestions are greatly appreciated!! |
#2
|
|||
|
|||
Total Detail on Continuous Form
If linetotal is a text box containing an expression, use the expression
itself instead of linetotal: =Sum([Something]*[SomethingElse]) Vinny wrote: I have a form based on one table and a subform based on another table. They are linked on a common identifier. The subform is setup as a continuous form. The main form contains repair order information, including the repair rates. The subform contains the actual repair information (description / body hours / refinish hours / etc). I have hidden fields doing calculations in each line (calculating part price with discount / rate from main form * hours in subform / and a line total). All of this is working great! Now I need to total down for a total cost of repairs. I have gone into my subform and inserted a text box into my form footer with the following information in the Control Source: =sum([linetotal]) but when I view the form in Form View, all I get is: #Error Any suggestions are greatly appreciated!! -- Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
Total Detail on Continuous Form
Just tried this again and all I get is #Error
"BruceM via AccessMonster.com" wrote: If linetotal is a text box containing an expression, use the expression itself instead of linetotal: =Sum([Something]*[SomethingElse]) Vinny wrote: I have a form based on one table and a subform based on another table. They are linked on a common identifier. The subform is setup as a continuous form. The main form contains repair order information, including the repair rates. The subform contains the actual repair information (description / body hours / refinish hours / etc). I have hidden fields doing calculations in each line (calculating part price with discount / rate from main form * hours in subform / and a line total). All of this is working great! Now I need to total down for a total cost of repairs. I have gone into my subform and inserted a text box into my form footer with the following information in the Control Source: =sum([linetotal]) but when I view the form in Form View, all I get is: #Error Any suggestions are greatly appreciated!! -- Message posted via http://www.accessmonster.com . |
#4
|
|||
|
|||
Total Detail on Continuous Form
Please post the expression you tried.
Vinny wrote: Just tried this again and all I get is #Error If linetotal is a text box containing an expression, use the expression itself instead of linetotal: [quoted text clipped - 17 lines] Any suggestions are greatly appreciated!! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201004/1 |
#5
|
|||
|
|||
Total Detail on Continuous Form
=Sum([PM]+[OEMwDiscount]+[QRPwMarkUp]+[LaborTotal]+[SalesTax])
Also, when I try to total just one of those fields, it only displays the information for the first record on this form. Example: =sum([PM]) Thanks for your help "BruceM via AccessMonster.com" wrote: Please post the expression you tried. Vinny wrote: Just tried this again and all I get is #Error If linetotal is a text box containing an expression, use the expression itself instead of linetotal: [quoted text clipped - 17 lines] Any suggestions are greatly appreciated!! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201004/1 . |
#6
|
|||
|
|||
Total Detail on Continuous Form
Just to be clear, are all of the following true?
PM is a field in the form's Record Source PM is a number or currency field There are several records in the form's recordset If the above are true, are you saying that an unbound text box with =Sum([PM]) as the Control Source shows only the value of the PM field in the first record? Vinny wrote: =Sum([PM]+[OEMwDiscount]+[QRPwMarkUp]+[LaborTotal]+[SalesTax]) Also, when I try to total just one of those fields, it only displays the information for the first record on this form. Example: =sum([PM]) Thanks for your help Please post the expression you tried. [quoted text clipped - 5 lines] Any suggestions are greatly appreciated!! -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|