View Single Post
  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Doug Robbins - Word MVP
 
Posts: n/a
Default Help! Form fields in table and calculations!

No, you need to use the Bookmarks item on the Insert menu to bookmark the
whole table.

For what you have done, you must have some formfields in the table and the
bookmark that you have created will only include the first of those
formfields.

When you insert the bookmark via the Insert menu and you turn on the display
of Bookmarks under ToolsOptionsView, you will see the [ marking the
beginning of the bookmark as the first item in the first cell of the table
and the ] marking the end of the bookmark will be outside the table to the
right of the last cell in the last row.

--
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

"R.P.McMurphy" wrote in message
...
I have book marked the table by clicking on the table anchor to highlight
the table and clicking form field options button on the forms toolbar and
then typing 'table1' in the bookmark box. I then, in the formula
mentioned, added table1 before every cell reference. but its still not
working for some reason. am I doing this right?

cheers

Steve

"Doug Robbins - Word MVP" wrote in message
...
From the Help file:

To reference cells in another table, or to reference a cell from outside
a table, identify the table with a bookmark (bookmark: A location or
selection of text in a file that you name for reference purposes.
Bookmarks identify a location within your file that you can later refer
or link to.). For example, the field { =average(Table2 b:b) } averages
column B in the table marked by the bookmark Table2.

--
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

"R.P.McMurphy" wrote in message
...
Hi all, can someone change this formula-

=(SUM(C9,C17,C25,J9,J17,J25)-6*39+ABS(C9-39)+ABS(C17-39)+ABS(C25-39)+ABS(J9-39)+ABS(J17-39)+ABS(J25-39))/2

to read from the cells in table1?

The form has two tables with form fields in, the first is the input
table, the second is the output or results table. The above works well
in a cell in the input table, but will not work in the output table, it
gives strange results!

Many Thanks!

Steve