View Single Post
  #2  
Old March 26th, 2010, 04:00 PM posted to microsoft.public.word.tables
macropod[_2_]
external usenet poster
 
Posts: 2,402
Default How to insert formula on a fill in form that adds columns

Hi ettadanreb,

On the 'totals' row for the column concerned, create a formula field by pressing Ctrl-F9. You should see a pair of field braces (ie
'{ }'). Between the field braces, type =SUM(ABOVE), so that you end up with '{=SUM(ABOVE)}'. Then, with the properties of each
formfield that contributes to the total, ensure the:
.. data type is set to number, with the appropriate format;
.. default value is set to whatever you want it to be (not empty); and
.. 'calculate on exit' option is checked.
When you're done, protect the form.

--
Cheers
macropod
[Microsoft MVP - Word]


"ettadanreb" wrote in message news
I set up my fill in form as a table. The user types the numbers in the
columns. I need the columns to add at the bottom of the column and give me a
total.