formtotal

[Verkoop]

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

Maarten

[Rick Wannall]

Re: formtotal

Not within the subform.

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

=mysub.Form!txt MyTotal

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

Re: formtotal

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" <wannall@notado main.de> wrote in message
news:aCkig.1455 85$F_3.44879@ne wssvr29.news.pr odigy.net...[color=blue]
> Not within the subform.
>
> However, in the main form you can put a textbox with this controlsource:
>
> =mysub.Form!txt MyTotal
>
> (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.[/color]

[Larry Linson]

Re: formtotal

"Verkoop" wrote
[color=blue]
> Thanx! That works very good!
> Exept when the field to total is a calculated
> field. Do you also have a solution for this
> problem.[/color]

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]

Re: formtotal

Thanx that works perfect.

"Larry Linson" <bouncer@localh ost.not> wrote in message
news:AMEig.2035 $X02.37@trnddc0 2...[color=blue]
> "Verkoop" wrote
>[color=green]
> > Thanx! That works very good!
> > Exept when the field to total is a calculated
> > field. Do you also have a solution for this
> > problem.[/color]
>
> 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
>[/color]