Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.word.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 | |
|
|
![]() |
||||
Thread | Forum | |||
Form Fields and Tables | Page Layout | |||
Formatting - Tables Nested In Fields | Mailmerge | |||
Form Fields in Tables | Tables | |||
What does "a field calcuation error occurred..." mean? | Mailmerge | |||
Referencing Text fields in tables | Tables |