adding up in subforms

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

could you please explain to me how to acheive this

thanks
 
J

John Vinson

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

could you please explain to me how to acheive this

thanks
Click to expand...

Open the subform in design view. You need to have it as a Continuous
Form (on the default view property), so you can use the subform's
Footer to do the calculation - datasheets don't show the footer.

Select View... Form Footer to make the footer visible; in that footer
put a textbox with a Control Source

=Sum([fieldname])

where fieldname is your subtotal field.

John W. Vinson[MVP]
 
Top