A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Help with calculation in a form.



 
 
Thread Tools Display Modes
  #1  
Old April 13th, 2006, 10:28 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default 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  
Old April 14th, 2006, 01:26 AM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default 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  
Old April 18th, 2006, 09:06 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 02:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.