formtotal

[Verkoop]

Does anyone know a way to view a total of a subform that has datasheet
format?

Maarten

[Rick Wannall]

Not within the subform.

However, in the main form you can put a textbox with this controlsource:

=mysub.Form!txtMyTotal

(include the equal sign)

This "reaches down" into the subform that copies the sum from the summing
textbox there up to the main form control.

Just put the summing textbox (here it's txtMyTotal in the form footer of the
subform, even though the subform will be in datasheet and you will not see
the total anywhere in the subform.

[Verkoop]

Thanx! That works very good!
Exept when the field to total is a calculated field. Do you also have a
solution for this problem.


"Rick Wannall" <wa*****@notadomain.de> wrote in message
news:aC********************@newssvr29.news.prodigy .net...

Not within the subform.

However, in the main form you can put a textbox with this controlsource:

=mysub.Form!txtMyTotal

(include the equal sign)

This "reaches down" into the subform that copies the sum from the summing
textbox there up to the main form control.

Just put the summing textbox (here it's txtMyTotal in the form footer of
the
subform, even though the subform will be in datasheet and you will not see
the total anywhere in the subform.

[Larry Linson]

"Verkoop" wrote

Thanx! That works very good!
Exept when the field to total is a calculated
field. Do you also have a solution for this
problem.

The Sum function works fine on a calculated _Field_, which you would
calculate in the Query you use as Record Source.

Sum does not work on a calculated _Control_, which you would calculate in
its Control Source.

Generally, you can create a Sum Control where the calculation for the
individual Controls is the argument to Sum, such as:

= Sum([Units]*[CostPerUnit])
Larry Linson
Microsoft Access MVP

[Verkoop]

Thanx that works perfect.

"Larry Linson" <bo*****@localhost.not> wrote in message
news:AMEig.2035$X02.37@trnddc02...

"Verkoop" wrote

Thanx! That works very good!
Exept when the field to total is a calculated
field. Do you also have a solution for this
problem.

The Sum function works fine on a calculated _Field_, which you would
calculate in the Query you use as Record Source.

Sum does not work on a calculated _Control_, which you would calculate in
its Control Source.

Generally, you can create a Sum Control where the calculation for the
individual Controls is the argument to Sum, such as:

= Sum([Units]*[CostPerUnit])
Larry Linson
Microsoft Access MVP