If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sum a column in a table
I have two column table: the first column has text and the second column has numbers, i would like to sum the second column. Can this be done? if so can it be done automaticly?
|
#2
|
|||
|
|||
Sum a column in a table
jm,
Yes and yes (with conditions) You can sum a column of numbers in a basic table using a formula field. { =sum(above) } Type: =sum(above) select the express, press CTRL+F9, right click the expression and press update fields. If you change the numbers in the column you will need to update the field again. Another option is to use text fields in a protected form formatted to calculate on exit. -----Original Message----- I have two column table: the first column has text and the second column has numbers, i would like to sum the second column. Can this be done? if so can it be done automaticly? . |
#3
|
|||
|
|||
Sum a column in a table
I have a very similar question. I do want to protect
this this table as a form, how do I set it to calculate on exit? Is this automatic? Thanks -----Original Message----- jm, Yes and yes (with conditions) You can sum a column of numbers in a basic table using a formula field. { =sum(above) } Type: =sum(above) select the express, press CTRL+F9, right click the expression and press update fields. If you change the numbers in the column you will need to update the field again. Another option is to use text fields in a protected form formatted to calculate on exit. -----Original Message----- I have two column table: the first column has text and the second column has numbers, i would like to sum the second column. Can this be done? if so can it be done automaticly? . . |
Thread Tools | |
Display Modes | |
|
|