Help with table sums PLEASE

[spam]

I have a table with 10 rows.

I would like to have an 11th row that holds the sum
of the rows 7 - 10. How can this be done?

Also:

I have a form that lets you select products, and it will display its price in a text box. How can I add all
the text box totals and put them in another text box?

Thanks For Your Help

 

[DougP]

Yes, on your form you can have a totals box that reflects the sum of something.

it would be
=sum(me![your field])
I would make a subform that has the records you need in it
Like the items on an Invoice.
then the textgbox on your main form would be

=Sum([Your subform].[Form]![field to Total]) DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[spam]

Can you be a bit more specific please?

I am new to access...


Thanks