Hi I have sql table I want to calculate all the fields to total sum field.
You can do this in the SELECT statement you use to get the data, something like
SELECT *, big1 + small1 as "TotalSum"
Obviously, you can add more numeric fields to the fields to sum.