Total Detail on Continuous Form

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

 

[BruceM via AccessMonster.com]

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

 

[Vinny]

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:

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

 

[BruceM via AccessMonster.com]

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]

 

[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

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

--



.

 

[BruceM via AccessMonster.com]

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?

=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]