#1
|
|||
|
|||
How to create calculated fields in Word
Hi, I know how to do this in Access but for some reason I can't this to work in Word I have created a simple form with [Number1] and [Number2] I have created a [Total] field and selected Type as 'Calculation' and written the expression as =Number2-Number1 with the text as #,##0 The result remains as 0 - I'm not sure what I am doing wrong Any help much appreciated |
#2
|
||||
|
||||
Hi Gooford,
You can use a formula field coded as: {=Number1+Number2 \# ",0"} Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. Also, with your Number1 & Number2 formfields, make sure their 'calculate on exit' property is checked.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Form Fields - Create blank form text field with if statement? | LAssist2011 | Word | 5 | 12-14-2011 03:02 PM |
Calculate date in word field | edwedw | Mail Merge | 3 | 11-30-2011 02:10 PM |
Calculate elapsed time in Word table? | Snvlsfoal | Word Tables | 1 | 08-11-2011 05:42 AM |
create letter template with fixed position fields and follow up pages | Lynn O'Shea | Word | 3 | 05-18-2010 12:32 AM |
Word - Calculate and paste values from Excel sheet | Augf87 | Word | 1 | 07-06-2009 10:26 AM |