Total Detail on Continuous Form
in [Form]
|
From: Vinny on 8 Apr 2010 09:48 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!!
From: BruceM via AccessMonster.com on 8 Apr 2010 10:10 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
From: Vinny on 8 Apr 2010 18:18 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 > > . >
From: BruceM via AccessMonster.com on 9 Apr 2010 10:32 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/Forums.aspx/access-forms/201004/1
From: Vinny on 9 Apr 2010 11:52
=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/Forums.aspx/access-forms/201004/1 > > . > |