My friend has asked me to generate her a Word document that is essentially a template that can be used where she works.
Within this document is a few simple calculations. So far I have a word document that has certain regions locked off so that the only areas available to write in have been set by me.
This will ultimately offer her work members a faster and neater document to enter information into rather than hand written.
The problem I have however is getting formula/Calculations to work in it.
Here's an Example:
Price :
Accessories :
Sub Total :
Deposit :
Total :
Let's say the word document has the above areas that information can be entered into. All fields will be numerical £.
The price will be in putted manually.
Accessories will be in putted manually.
Sub total : Formula that adds Price + Accessories together.
Deposit : in putted manually
Total : Sub Total - the deposit.
What is the best method of calculating the above? Can I use the 'Text Form Field' with a label added for the bookmark?
Or must I create a Table and base the formula/Calculations on that?
If so, how would I do that?
___
I've created a table as a test that has the following:
Column 1 Column 2
Price £100
Accessories £200
Total Price =SUM(b1)+(b2)
If the document is locked and the user inputs the information into the field. The Total price row does not update. However if I hover over the formula, right click and choose UPDATE FIELD then the correct calculation appears.
This however is not good for what I want as I want the field to automatically update if possible.
Any word 2003 wizards that can advise me on the best method for the above problem.
Any suggestions or different ways to approach this would be greatly appreciated.
Thanks in Advance.
Within this document is a few simple calculations. So far I have a word document that has certain regions locked off so that the only areas available to write in have been set by me.
This will ultimately offer her work members a faster and neater document to enter information into rather than hand written.
The problem I have however is getting formula/Calculations to work in it.
Here's an Example:
Price :
Accessories :
Sub Total :
Deposit :
Total :
Let's say the word document has the above areas that information can be entered into. All fields will be numerical £.
The price will be in putted manually.
Accessories will be in putted manually.
Sub total : Formula that adds Price + Accessories together.
Deposit : in putted manually
Total : Sub Total - the deposit.
What is the best method of calculating the above? Can I use the 'Text Form Field' with a label added for the bookmark?
Or must I create a Table and base the formula/Calculations on that?
If so, how would I do that?
___
I've created a table as a test that has the following:
Column 1 Column 2
Price £100
Accessories £200
Total Price =SUM(b1)+(b2)
If the document is locked and the user inputs the information into the field. The Total price row does not update. However if I hover over the formula, right click and choose UPDATE FIELD then the correct calculation appears.
This however is not good for what I want as I want the field to automatically update if possible.
Any word 2003 wizards that can advise me on the best method for the above problem.
Any suggestions or different ways to approach this would be greatly appreciated.
Thanks in Advance.
