calculation with two tables

[Eric]

Hi!
There are two separate tables on my document and there is a total field
(=sum(above)) at the last row of the first table. I want to also show that
total value of the first table at the first row of the second table. Because
there is another calculation on the second table.
Can I add a field at the first row of the second table to refresh the value
from the first table? How?
Thank you very much!

 

[Luc]

Eric,
Select your total in the first table. Bookmark it, Insert - bookmark - type
a name like firsttotal - OK
In the first row of your second table use a ref field, Insert - Field -
Ref - select your bookmark - OK.
You will have to recalculate using Ctrl+a - F9 to update after changes made
to the numbers in your table.
Luc

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?RXJpYw==?=,

There are two separate tables on my document and there is a total field
(=sum(above)) at the last row of the first table. I want to also show that
total value of the first table at the first row of the second table. Because
there is another calculation on the second table.
Can I add a field at the first row of the second table to refresh the value
from the first table? How?

Yes. It's described in the Help files...

"To reference cells in another table, or to reference a cell from outside a
table, identify the table with a bookmark. For example, the field {
=average(Table2 b:b) } averages column B in the table marked by the bookmark
Table2."

What this doesn't tell you is:
- You need to select the entire table, then Insert/Bookmark and type in the
bookmark name (Table2, for example)
- This only works when you use the bookmark in a FUNCTION. If you only want
to show the result of a single cell, you still need to do something like
{ = SUM(Table1 A1:A1) }

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail