A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

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 » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Microsoft Word Help
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Can word calculate a column in a table in a form template?



 
 
Thread Tools Display Modes
  #1  
Old July 2nd 07, 08:14 PM posted to microsoft.public.word.docmanagement
Bettina
external usenet poster
 
Posts: 34
Default Can word calculate a column in a table in a form template?

Hi.

I have a template that works like a form where people enter information into
text boxes.

One part of the form has a table and I want people to enter numbers into one
column. I would like the subtotal and total column to automatically add up
whatever numbers are entered.

Is this possible?
--
Bettina
Ads
  #2  
Old July 3rd 07, 07:02 AM posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill
external usenet poster
 
Posts: 33,626
Default Can word calculate a column in a table in a form template?

Use a calculation form field; that is, insert a text form field and, in the
Form Field Options, choose Calculation as the type and enter the desired
formula.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Bettina" wrote in message
...
Hi.

I have a template that works like a form where people enter information

into
text boxes.

One part of the form has a table and I want people to enter numbers into

one
column. I would like the subtotal and total column to automatically add up
whatever numbers are entered.

Is this possible?
--
Bettina


  #3  
Old July 3rd 07, 02:46 PM posted to microsoft.public.word.docmanagement
Bettina
external usenet poster
 
Posts: 34
Default Can word calculate a column in a table in a form template?

Thank you for your speedy reply Susan.

When I choose insert field, I'm not sure what item to choose on the left
side to get a calculation. Also, if I have 10 cells where people will enter
the numbers, am I to put a code in those cells or just in the subtotal and
total cell that will add up the numbers?

Please advise.
Thanks soooo much!
--
Bettina


"Suzanne S. Barnhill" wrote:

Use a calculation form field; that is, insert a text form field and, in the
Form Field Options, choose Calculation as the type and enter the desired
formula.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Bettina" wrote in message
...
Hi.

I have a template that works like a form where people enter information

into
text boxes.

One part of the form has a table and I want people to enter numbers into

one
column. I would like the subtotal and total column to automatically add up
whatever numbers are entered.

Is this possible?
--
Bettina



  #4  
Old July 3rd 07, 02:52 PM posted to microsoft.public.word.docmanagement
Bettina
external usenet poster
 
Posts: 34
Default Can word calculate a column in a table in a form template?

Okay, I re-read your reply and entered a text form field in each cell of the
column I would like to automatically sum once numbers are entered.

Here's my confusion: when I place my cursor in the subtotal cell and choose
insert, field, there's no category for calculation. There is a box to choose
formula and if I choose that it wants a range?

Please help -- thank you!
--
Bettina


"Suzanne S. Barnhill" wrote:

Use a calculation form field; that is, insert a text form field and, in the
Form Field Options, choose Calculation as the type and enter the desired
formula.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Bettina" wrote in message
...
Hi.

I have a template that works like a form where people enter information

into
text boxes.

One part of the form has a table and I want people to enter numbers into

one
column. I would like the subtotal and total column to automatically add up
whatever numbers are entered.

Is this possible?
--
Bettina



  #5  
Old July 3rd 07, 04:08 PM posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill
external usenet poster
 
Posts: 33,626
Default Can word calculate a column in a table in a form template?

I think I misread your original post and thought you were already using form
fields in a protected form. If you are, then a calculation field is one type
of Text Form Field. If you're just using an unprotected table, then you can
use Formula fields, but you have to specify the range (the easiest, of
course, is Sum(Above), but that has limitations); see the Help topics
"Perform calculations in a table" and "Referencing cells in a table."

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Bettina" wrote in message
...
Okay, I re-read your reply and entered a text form field in each cell of

the
column I would like to automatically sum once numbers are entered.

Here's my confusion: when I place my cursor in the subtotal cell and

choose
insert, field, there's no category for calculation. There is a box to

choose
formula and if I choose that it wants a range?

Please help -- thank you!
--
Bettina


"Suzanne S. Barnhill" wrote:

Use a calculation form field; that is, insert a text form field and, in

the
Form Field Options, choose Calculation as the type and enter the desired
formula.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the

newsgroup so
all may benefit.

"Bettina" wrote in message
...
Hi.

I have a template that works like a form where people enter

information
into
text boxes.

One part of the form has a table and I want people to enter numbers

into
one
column. I would like the subtotal and total column to automatically

add up
whatever numbers are entered.

Is this possible?
--
Bettina




  #6  
Old July 3rd 07, 04:52 PM posted to microsoft.public.word.docmanagement
Bettina
external usenet poster
 
Posts: 34
Default Can word calculate a column in a table in a form template?

Susan,

I'm really confused. I have created a document with text field boxes so that
people can enter numbers, check boxes, etc. One column of my table should
also have text field boxes for people to enter numbers. However, I want the
subtotal cell below it and the total below the subtotal to add the numbers
automatically based on what a person enters.

When I click on a given cell in the column, I add a text field and I have
chosen properties where I have changed the type to "calculation". The
expression box automatically adds a =. The max length is unlimited.'

I noticed that the text field box automatically locks now. I have 13 cells
in a column in a table where I want user's to enter numbers that will
automatically add up in the subtotal and total cell in the same column.

One of the reasons why I'm inquiring here is because I tried to make sense
of the help menu in word all day yesterday.

Please help. Thank you.
--
Bettina


"Suzanne S. Barnhill" wrote:

I think I misread your original post and thought you were already using form
fields in a protected form. If you are, then a calculation field is one type
of Text Form Field. If you're just using an unprotected table, then you can
use Formula fields, but you have to specify the range (the easiest, of
course, is Sum(Above), but that has limitations); see the Help topics
"Perform calculations in a table" and "Referencing cells in a table."

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Bettina" wrote in message
...
Okay, I re-read your reply and entered a text form field in each cell of

the
column I would like to automatically sum once numbers are entered.

Here's my confusion: when I place my cursor in the subtotal cell and

choose
insert, field, there's no category for calculation. There is a box to

choose
formula and if I choose that it wants a range?

Please help -- thank you!
--
Bettina


"Suzanne S. Barnhill" wrote:

Use a calculation form field; that is, insert a text form field and, in

the
Form Field Options, choose Calculation as the type and enter the desired
formula.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the

newsgroup so
all may benefit.

"Bettina" wrote in message
...
Hi.

I have a template that works like a form where people enter

information
into
text boxes.

One part of the form has a table and I want people to enter numbers

into
one
column. I would like the subtotal and total column to automatically

add up
whatever numbers are entered.

Is this possible?
--
Bettina




  #7  
Old July 3rd 07, 05:04 PM posted to microsoft.public.word.docmanagement
Bettina
external usenet poster
 
Posts: 34
Default Can word calculate a column in a table in a form template?

Suzanne,

For every cell in the table before the subtotal column, I have placed a text
field box and under properties, have the code =sum(above). For the subtotal
cell, I have done the same. The subtotal cell is not adding a total for the
numbers I am entering. Also, the form fields freeze if I lock the sheet which
I need to because of the text fields.

Please tell me what I need to do in each cell so that a user can enter a
number and what to place in the subtotal cell and cells inbetween and the
final total cell. I'm having problems figuring this out.

Please let me know if you need further explanation.
Thanks so much!!!--
Bettina


"Suzanne S. Barnhill" wrote:

I think I misread your original post and thought you were already using form
fields in a protected form. If you are, then a calculation field is one type
of Text Form Field. If you're just using an unprotected table, then you can
use Formula fields, but you have to specify the range (the easiest, of
course, is Sum(Above), but that has limitations); see the Help topics
"Perform calculations in a table" and "Referencing cells in a table."

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Bettina" wrote in message
...
Okay, I re-read your reply and entered a text form field in each cell of

the
column I would like to automatically sum once numbers are entered.

Here's my confusion: when I place my cursor in the subtotal cell and

choose
insert, field, there's no category for calculation. There is a box to

choose
formula and if I choose that it wants a range?

Please help -- thank you!
--
Bettina


"Suzanne S. Barnhill" wrote:

Use a calculation form field; that is, insert a text form field and, in

the
Form Field Options, choose Calculation as the type and enter the desired
formula.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the

newsgroup so
all may benefit.

"Bettina" wrote in message
...
Hi.

I have a template that works like a form where people enter

information
into
text boxes.

One part of the form has a table and I want people to enter numbers

into
one
column. I would like the subtotal and total column to automatically

add up
whatever numbers are entered.

Is this possible?
--
Bettina




  #8  
Old July 3rd 07, 06:59 PM posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill
external usenet poster
 
Posts: 33,626
Default Can word calculate a column in a table in a form template?

When you protect the form, users can't type anywhere except where you've
placed form fields. That's the way forms work; you may want to read the
forms tutorials by Dian Chapman that are linked from
http://word.mvps.org/FAQs/Customizat...nTheBlanks.htm. When you
designate a Text Form Field as a calculation type, then user entry is
prohibited there as well; the content of the field depends on the
calculation. You should not be putting formulas in the fields where you want
users to enter numbers; you only want the formula where you want the
subtotal or total. Also, for all the form fields that contribute to the
calculation, you need to check the box for "Calculate on exit." Also, note
that calculations based on calculated fields may be incorrect; see “WD2000:
Calculation in Form Field Shows Wrong Result” at
http://support.microsoft.com/?kbid=211253

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Bettina" wrote in message
...
Suzanne,

For every cell in the table before the subtotal column, I have placed a

text
field box and under properties, have the code =sum(above). For the

subtotal
cell, I have done the same. The subtotal cell is not adding a total for

the
numbers I am entering. Also, the form fields freeze if I lock the sheet

which
I need to because of the text fields.

Please tell me what I need to do in each cell so that a user can enter a
number and what to place in the subtotal cell and cells inbetween and the
final total cell. I'm having problems figuring this out.

Please let me know if you need further explanation.
Thanks so much!!!--
Bettina


"Suzanne S. Barnhill" wrote:

I think I misread your original post and thought you were already using

form
fields in a protected form. If you are, then a calculation field is one

type
of Text Form Field. If you're just using an unprotected table, then you

can
use Formula fields, but you have to specify the range (the easiest, of
course, is Sum(Above), but that has limitations); see the Help topics
"Perform calculations in a table" and "Referencing cells in a table."

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the

newsgroup so
all may benefit.

"Bettina" wrote in message
...
Okay, I re-read your reply and entered a text form field in each cell

of
the
column I would like to automatically sum once numbers are entered.

Here's my confusion: when I place my cursor in the subtotal cell and

choose
insert, field, there's no category for calculation. There is a box to

choose
formula and if I choose that it wants a range?

Please help -- thank you!
--
Bettina


"Suzanne S. Barnhill" wrote:

Use a calculation form field; that is, insert a text form field and,

in
the
Form Field Options, choose Calculation as the type and enter the

desired
formula.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the

newsgroup so
all may benefit.

"Bettina" wrote in message
...
Hi.

I have a template that works like a form where people enter

information
into
text boxes.

One part of the form has a table and I want people to enter

numbers
into
one
column. I would like the subtotal and total column to

automatically
add up
whatever numbers are entered.

Is this possible?
--
Bettina





  #9  
Old July 3rd 07, 07:36 PM posted to microsoft.public.word.docmanagement
Bettina
external usenet poster
 
Posts: 34
Default Can word calculate a column in a table in a form template?

I understand about forms. I've run into this problem because in my doc. I'd
like people to be able to enter numbers into a column of a table and have
them automatically add. The questions I've asked haven't been answered and I
really don't know why.

Thanks anyway.
--
Bettina


"Suzanne S. Barnhill" wrote:

When you protect the form, users can't type anywhere except where you've
placed form fields. That's the way forms work; you may want to read the
forms tutorials by Dian Chapman that are linked from
http://word.mvps.org/FAQs/Customizat...nTheBlanks.htm. When you
designate a Text Form Field as a calculation type, then user entry is
prohibited there as well; the content of the field depends on the
calculation. You should not be putting formulas in the fields where you want
users to enter numbers; you only want the formula where you want the
subtotal or total. Also, for all the form fields that contribute to the
calculation, you need to check the box for "Calculate on exit." Also, note
that calculations based on calculated fields may be incorrect; see “WD2000:
Calculation in Form Field Shows Wrong Result” at
http://support.microsoft.com/?kbid=211253

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Bettina" wrote in message
...
Suzanne,

For every cell in the table before the subtotal column, I have placed a

text
field box and under properties, have the code =sum(above). For the

subtotal
cell, I have done the same. The subtotal cell is not adding a total for

the
numbers I am entering. Also, the form fields freeze if I lock the sheet

which
I need to because of the text fields.

Please tell me what I need to do in each cell so that a user can enter a
number and what to place in the subtotal cell and cells inbetween and the
final total cell. I'm having problems figuring this out.

Please let me know if you need further explanation.
Thanks so much!!!--
Bettina


"Suzanne S. Barnhill" wrote:

I think I misread your original post and thought you were already using

form
fields in a protected form. If you are, then a calculation field is one

type
of Text Form Field. If you're just using an unprotected table, then you

can
use Formula fields, but you have to specify the range (the easiest, of
course, is Sum(Above), but that has limitations); see the Help topics
"Perform calculations in a table" and "Referencing cells in a table."

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the

newsgroup so
all may benefit.

"Bettina" wrote in message
...
Okay, I re-read your reply and entered a text form field in each cell

of
the
column I would like to automatically sum once numbers are entered.

Here's my confusion: when I place my cursor in the subtotal cell and
choose
insert, field, there's no category for calculation. There is a box to
choose
formula and if I choose that it wants a range?

Please help -- thank you!
--
Bettina


"Suzanne S. Barnhill" wrote:

Use a calculation form field; that is, insert a text form field and,

in
the
Form Field Options, choose Calculation as the type and enter the

desired
formula.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so
all may benefit.

"Bettina" wrote in message
...
Hi.

I have a template that works like a form where people enter
information
into
text boxes.

One part of the form has a table and I want people to enter

numbers
into
one
column. I would like the subtotal and total column to

automatically
add up
whatever numbers are entered.

Is this possible?
--
Bettina






  #10  
Old July 3rd 07, 11:14 PM posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill
external usenet poster
 
Posts: 33,626
Default Can word calculate a column in a table in a form template?

The calculation field will produce the sum automatically provided all the
contributing Text Form Fields have "Calculate on exit" checked.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Bettina" wrote in message
...
I understand about forms. I've run into this problem because in my doc.

I'd
like people to be able to enter numbers into a column of a table and have
them automatically add. The questions I've asked haven't been answered

and I
really don't know why.

Thanks anyway.
--
Bettina


"Suzanne S. Barnhill" wrote:

When you protect the form, users can't type anywhere except where you've
placed form fields. That's the way forms work; you may want to read the
forms tutorials by Dian Chapman that are linked from
http://word.mvps.org/FAQs/Customizat...nTheBlanks.htm. When you
designate a Text Form Field as a calculation type, then user entry is
prohibited there as well; the content of the field depends on the
calculation. You should not be putting formulas in the fields where you

want
users to enter numbers; you only want the formula where you want the
subtotal or total. Also, for all the form fields that contribute to the
calculation, you need to check the box for "Calculate on exit." Also,

note
that calculations based on calculated fields may be incorrect; see

“WD2000:
Calculation in Form Field Shows Wrong Result” at
http://support.microsoft.com/?kbid=211253

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the

newsgroup so
all may benefit.

"Bettina" wrote in message
...
Suzanne,

For every cell in the table before the subtotal column, I have placed

a
text
field box and under properties, have the code =sum(above). For the

subtotal
cell, I have done the same. The subtotal cell is not adding a total

for
the
numbers I am entering. Also, the form fields freeze if I lock the

sheet
which
I need to because of the text fields.

Please tell me what I need to do in each cell so that a user can enter

a
number and what to place in the subtotal cell and cells inbetween and

the
final total cell. I'm having problems figuring this out.

Please let me know if you need further explanation.
Thanks so much!!!--
Bettina


"Suzanne S. Barnhill" wrote:

I think I misread your original post and thought you were already

using
form
fields in a protected form. If you are, then a calculation field is

one
type
of Text Form Field. If you're just using an unprotected table, then

you
can
use Formula fields, but you have to specify the range (the easiest,

of
course, is Sum(Above), but that has limitations); see the Help

topics
"Perform calculations in a table" and "Referencing cells in a

table."

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the

newsgroup so
all may benefit.

"Bettina" wrote in message
...
Okay, I re-read your reply and entered a text form field in each

cell
of
the
column I would like to automatically sum once numbers are entered.

Here's my confusion: when I place my cursor in the subtotal cell

and
choose
insert, field, there's no category for calculation. There is a box

to
choose
formula and if I choose that it wants a range?

Please help -- thank you!
--
Bettina


"Suzanne S. Barnhill" wrote:

Use a calculation form field; that is, insert a text form field

and,
in
the
Form Field Options, choose Calculation as the type and enter the

desired
formula.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so
all may benefit.

"Bettina" wrote in message
...
Hi.

I have a template that works like a form where people enter
information
into
text boxes.

One part of the form has a table and I want people to enter

numbers
into
one
column. I would like the subtotal and total column to

automatically
add up
whatever numbers are entered.

Is this possible?
--
Bettina







 




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 On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to calculate totals in a Word form Knoxwell Tables 1 January 7th 06 04:27 AM
Can Word calculate page number in form only if data is entered in. Jim Page Layout 1 December 20th 05 09:59 AM
How do I get form fields to calculate in Word? Mystified Mike Microsoft Word Help 1 December 18th 05 04:13 AM
Form Field to total a column in a table? Katherine Smith Microsoft Word Help 1 July 21st 05 08:04 PM
How do I calculate page numbers ina 2 column document Liz S Page Layout 2 February 10th 05 12:49 PM


All times are GMT +1. The time now is 07:22 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.