Total Sum

[Simon]

I have a form based on a query that shows all the product that i sell
with how much revenue they made for 2006 and 2007 (to date) and then
the total over all for each product


What is the best way at the bottom of the form to have a sum for all
the product for 2006 and 2007 and for both of them



Thanks

Simon

 

[storrboy]

I assume this a continous form.
If a continous form, add a textbox to the form footer and set the
Control Source to =Sum([FieldName]).
If a datasheet, you'll need to place it on another form as a subform,
add the textbox as above, and reference it on the main form.