subform sums

[Guest]

hey, i have a subform, that asks what product you want to choose, and the
quantity of that item, and it also works out the subtotal of each individual
product, but, i also want to add everything up and come get the Overall Total.

i can't seem to do it

i have looked at the Northwind example that comes with access, but i still
don't understand it.

could you please explain to me how to acheive this

thanks

 

[Al Camp]

Mat,
In the query behind your subform, create a "bound" calculated field (ex.
SubTotal)
SubTotal : Qty * Price
Place Subtotal on your subform records to show each record value, and in
the subform footer place an "unbound" text control (named OrderTotal) with
= Sum(SubTotal)
as the ControlSource. That should yield a total for the whole order.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[Guest]

hey, thanks for that, i get it now, but i have one more problem now

the subform is in datasheet view, and i used what you told me, and it
doesn't work in datasheet, but, it does work if the subform is in normal view.

how do i fix this?

thanks

 

[Al Camp]

See Sprink's response on Forms...

I hope you see now, why posting the same question individually to more than
one newsgroup is wrong. Sprinks has answered your questions, and I've just
been wasting my time duplicating his efforts...
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions