If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help with calculation in a form.
How do you enter a calculation within a table in a form template? I am
currently creating a Purchase Requisition and want two fields to multiply together so that the person filling out the form does not need to perform the calculation. I have tried everything within the help menu. I am using WORD 2002 and have Windows 2000 Professional. |
#2
|
|||
|
|||
Help with calculation in a form.
The two fields that the user fills out have names: right-click and select
properties. The defaults are names like Text1, Text2. Change these to something meaningful: Quantity, Price or whatever. Then use a calculation field: { = Quantity * Price } Then add a validation, so the user is warned if they enter a quantity or price that Word can't recognise as numeric. "Janine" wrote in message ... How do you enter a calculation within a table in a form template? I am currently creating a Purchase Requisition and want two fields to multiply together so that the person filling out the form does not need to perform the calculation. I have tried everything within the help menu. I am using WORD 2002 and have Windows 2000 Professional. |
#3
|
|||
|
|||
Help with calculation in a form.
I figured it out.
When performing a caluculation... ALL fields within a calculation must have the option to "calculate on exit" selected (not just the field that holds the calculation). "Janine" wrote: How do you enter a calculation within a table in a form template? I am currently creating a Purchase Requisition and want two fields to multiply together so that the person filling out the form does not need to perform the calculation. I have tried everything within the help menu. I am using WORD 2002 and have Windows 2000 Professional. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Controls disappear from Data Entry form | Paul Ponzelli | Using Forms | 10 | February 26th, 2006 05:51 AM |
Date range on reports | Mark_Milly | Setting Up & Running Reports | 10 | January 19th, 2006 03:49 PM |
Move feild entries from form to form using global variables | JackCGW | General Discussion | 11 | November 14th, 2005 05:22 AM |
Need Help In Printing Current Record in Specific Report | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 16th, 2005 09:06 PM |
auto entry into second table after update | Tony | New Users | 13 | July 9th, 2004 10:42 PM |