[Schuuch]

Does anyone know how to create a SUM ABOVE function in a table so when the
form is protected and the number fields are completed, the numbers in the
column above the function are automatically totalled?
I've inserted a Text Form Field in each cell with number properties and
bookmarked NUM1, NUM2, etc. In the cell where I want the sum to appear, I've
tried inserting a blank expression field {=NUM1+NUM2 \ #,###} as well as Text
Form Field with Calculate property and same formula, but the result is always
!SYNTAX Error. Any ideas out there?

[Doug Robbins - Word MVP]

The problem is with your formatting switch, which should be \# #,### (or
better \# ,# )

You can just use a { =Sum(Above) \# ,# } formula in the location where you
want the total to appear and check the Calculate on Exit box for each of the
formfields that will contribute to the result

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Schuuch" wrote in message
...
Does anyone know how to create a SUM ABOVE function in a table so when the
form is protected and the number fields are completed, the numbers in the
column above the function are automatically totalled?
I've inserted a Text Form Field in each cell with number properties and
bookmarked NUM1, NUM2, etc. In the cell where I want the sum to appear,
I've
tried inserting a blank expression field {=NUM1+NUM2 \ #,###} as well as
Text
Form Field with Calculate property and same formula, but the result is
always
!SYNTAX Error. Any ideas out there?