Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Calcuation fields in Tables
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 |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Calcuation fields in Tables
Almost forgot, since this form will go outside the company, I can not use any
macros that would require the user to set their macro security to medium if already set to high. Thanks "Jack_Feeman" wrote: 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 |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Calcuation fields in Tables
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 |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
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 |