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

  • Thread starter Thread starter BZeyger
  • Start date Start date
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?
 
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subform Datasheet Total Row 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Query Sum Amount To Table Field 1
Excel Allowing users to add rows in protected excel table 2
Percentage change 9
Total Row in datasheet view has problems if using ADP / SQL 4
Concatenate Rows 1
concatenation of multiple rows into a single row 2

Back
Top