subform sums

M

Mat

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
 
S

Sprinks

Hi, Mat.

You can only sum a table field, not a calculated control. So, assuming your
subform has the fields UnitPrice and Qty, with a calculated control Extd
equal to UnitPrice*Qty, the grand total would be, in the footer:

=Sum(UnitPrice*Qty).

Sprinks
 
M

Mat

thanks, that worked, thanks for your help

Sprinks said:
Hi, Mat.

You can only sum a table field, not a calculated control. So, assuming your
subform has the fields UnitPrice and Qty, with a calculated control Extd
equal to UnitPrice*Qty, the grand total would be, in the footer:

=Sum(UnitPrice*Qty).

Sprinks
Click to expand...
 
M

Mat

hey, i have one more problem
the subform that i have, is in datasheet view, and i can only get the total
function to work in normal view

how do i fix this???
thanks
 
A

Al Camp

Mat,
See my reply on...
microsoft.public.access
Please don't the same question on several newsgroups. While I'm
answering your question on one NG, someone else may be replying on another.
If you must "cross-post", keep it to a minimum, and include both NG
addresses on the one post. That way, if I answer on the "Access" NG... it
will also show up on the "Forms" NG.
Thanks,
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
S

Sprinks

Hi, Mat.

Datasheet view is basic and doesn't provide for summary controls, or headers
and footers for that matter. Use a continuous form instead.

Sprinks
 
Top