Sum a column in a table

[Greg]

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?

 

[James]

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

 

[Greg Maxey]

Jim,

After you enter each formfield, double click each one and set type (number),
format, and check the box adjacent to "calculate on exit." The result of the
formula field will be updated when you tab exit out of each formfield.