Add a row to a table to calculate the total per row

B

BZeyger

Hello,
I have a table named “Issues†that contains numerous bits of information. In
the table, I have rows that are set for currency for 2007, 2008, 2009, and
2010.
I created a form that displays this information. I now want to add another
row that calculates the sum to these rows. The table displays in a subform.
How would I do this?
 
K

KARL DEWEY

You can not!
A table stores data but can not calculate totals like a spreadsheet does.
Use a footer in your form for the total.
 
R

Ryan

In your forms footer you would place an unbound textbox. Lets call the first
one total2007. Right click total2007 and set the default value to =Sum[2007]
.. Thats it. The only other thing is that you will need this form to be in
"Continous Form" mode or it will only total the current record. Hope this
helps.
 
Top