Total Detail on Continuous Form


V

Vinny

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!!
 
Ad

Advertisements

V

Vinny

Just tried this again and all I get is #Error

BruceM via AccessMonster.com said:
If linetotal is a text box containing an expression, use the expression
itself instead of linetotal:

=Sum([Something]*[SomethingElse])

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!!
 
Ad

Advertisements

V

Vinny

=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 said:
Please post the expression you tried.
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


.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top