Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.word.tables
Jack_Feeman Jack_Feeman is offline
external usenet poster
 
Posts: 8
Default Calcuation fields in Tables

Thanks Peter, will give it a try. The columns spread over two pages so the
"=SUM(ABOVE)" formula did not seem to include the cells in the column on the
previous page so I switched to calling out each cell by bookmark. Thanks
again for such an expeditious reply.

"Peter Jamieson" wrote:

Try the following:

1. Instead of bookmarking your cell as ASSETS, create a text form field in
the cell and set its properties as:
Type: Calculation
Expression: the = formula you need to use to calculate the ASSETS value
Bookmark: Assets

2. Do the equivalent thing for DEBITS

3. Do the equivalent thing for the cell(or whatever) where you need the
Assets-Debits calculation.

Peter Jamieson
"Jack_Feeman" wrote in message
...
HI, need to tap on your expertise for a second. Word 2003 Form.

€¢ Have two columns of dollar amounts in a Word Table. These are each
bookmarked with an unique name from within the form field properties
dialog
box.

€¢ Each column ends with a calculation field summing the total of the
column
(done referencing each of the unique bookmarks above. The first column
summary field is bookmarked as "ASSETS" and the second as "DEBITS". These
bookmarks were assigned to the cell since the Word field edit box does not
have a place to assign a bookmark to the field.

€¢ Then there is a Networth calculation field (ASSETS-DEBITS) which should
be
calculated each time ASSETS or DEBITS is changed.

How do I get the NETworth field to (re)calcuate the ASSETS-DEBITS amount
each time any of the amount in the table changes since the Word Field
(Formula field) edit box does not have a calculate on exit toggle as the
form
fields do?
(As the user tabs through the form filling in the amounts, the column Sum
fields work great but the Networth fields does no calculations at all
since
the tabbing bypasses these calculation fields completely?)

Thanks Jack



 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Form Fields and Tables Carla Page Layout 1 May 5th 07 07:03 AM
Formatting - Tables Nested In Fields msnews.microsoft.com Mailmerge 2 June 27th 06 09:25 AM
Form Fields in Tables Patti B Tables 3 July 8th 05 04:11 PM
What does "a field calcuation error occurred..." mean? judyk Mailmerge 4 June 23rd 05 11:37 AM
Referencing Text fields in tables BigWylie1 Tables 0 October 26th 04 08:17 PM


All times are GMT +1. The time now is 05:26 AM.

Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"