Hi Doug, I have found another way of doing the same thing, leave the
calculation in a unused cell in table1, then set the cell in table2 where I
require the output of the calculation to just repeat what has been the
result of the calculation. I have used

=overtime1

but if overtime1 is 16

then result is coming up as 1616...why?

Steve

"Doug Robbins - Word MVP" wrote in message
...
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