When entering, into the text fields everything goes as planed. However when it calculates the overall total at the bottom automatically, it calculates it *11 it seems. If someone could go over this for me and check it out let me know what I do not understand here that would be great.

Thanks
So you are trying to use Word like a spreadsheet for calculations?And what version is this? And do you have Excel also?
I looked at your Word file and I can't get it to calculate, perhaps because my Word sees it as a read-only file. Doing something like this in Word seems quite odd. I'd much rather use Excel. Microsoft Word 2000 (9.0.2720)

Yeah your right, I might try to import an excel spreadsheet. Just thought that I would be able to do it in word with the text fields, since they can calculate and assign variables. Would have been nice if I could have gotten this to work, to keep all my inner office forms consistent.

Thanks


Paulpls try this:
Remove the text field of Total.
Then go to Insert->Field, under Categories, choose Equations and Formulas, then in Field Properties, click Formula. Use Sum(Above) as default. Click Ok.
Whenever you add the price, go to Total, right click and choose UPDATE field. It will show the correct amount
good luckHey, ghostdog74, that works, but what about a formula for multiplying QUANTITY X Price?i guess you could do that too...by using PRODUCT(qa,qb) etc....Well, surely he would want that, too. Did you look at the file? It has columns for Quantity and Price. Then, the total column must contain Quantity x Price. And then, the sum of the Total column would APPEAR at bottom, based on the formula you gave earlier. However, I can not get a product formula to work. Once I enter a value into the Quantity and Price fields, their character seems to change and a formula in the Total column will not calculate the product. Can you make that work? yes i did look at the document. one thing to note is , i have to fill into the text box ( and not delete it). Also, when i enter value of Qty, i double clicked the text box and i entered "Default number" = some number

for eg on one row

Qty Price Total <-- Qty and Price column still are text field forms.
1.0 2.0 2

In the Total column, i changed to Formula PRODUCT(qa,pa) , instead of a text field FORM.
Then in the final Total, i updated the field by right click.

I don't know whether this is the correct way, but i do get the results finally.
As some posters mentioned, Excel is more suited for this type of work.Thanks for taking time to explain that. And, I got it to work the same as you. But, it still seems very cumbersome, compared to using Excel for such an application. And, that seems to be the consensus here.no problem
yes, i agree... excel is better at such things...IMHOThanks for all the responses I will try your suggestions when I get back to the office.