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  

Getting a table to total columns



 
 
Thread Tools Display Modes
  #11  
Old June 4th, 2009, 02:41 PM posted to microsoft.public.word.tables
Graham Mayor
external usenet poster
 
Posts: 18,297
Default Getting a table to total columns

In that case plan B. Replace the calculated formfield with a conditional
field. If the field bookmark names remain A1 & A2

{ IF{ ={ A1 } * { A2 } } 0 { ={ A1 } * { A2 } \# "0.00"} }

Set the switch \# "0.00" appropriate to your needs
The field will show a syntax error if there is no value in A1 or A2, so set
those field types to number and put a default 0 in each.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Willem Nel wrote:
Thanks Doug!!! Form calculations now running smooth! Need one more
input from you, please. How do I get the result of a calculation to
not show 0. I want the field to be blank if result is 0.



Insert Text Input FormFields in A1 and A2 and set the Calculate on
Exit property of each. Assuming that you name bookmarks assigned to
those fields as A1 and a2, in A3, insert a calculation type
formfield that contains the expression =A1 * A2

See the following;

http://www.mousetrax.com/techpage.html#autoforms
Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and
keep better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Willem Nel" wrote in message
...
In tables in word:

A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2
All formulas work is template mode if number in A1 AND A2 is
recorded when formula is set. There after ctrl+a, f9 updates field
in template. If template
is protected or saved as word document A3 never changes when A1 OR
A2 changes. Ctrl+a, F9 or right click also does not work. Form with
calculation
of no use to customers or our company! Need to get A3 formula to
automaticly
update when A1 OR A2 changes if template is protected or saved as
word document. See book-keeping slip template under forms on online
templates. This is what formulas should do! Book-keeping slip is
protected and cannot see formula!

--
Wllem Nel


"Doug Robbins - Word MVP" wrote:

Can you provide more details of what you want to do?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of
my services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Willem Nel" wrote in message
...
Ctrl+A, F9 works in template (not protected). When the form is
with a customer or user no formulas operates the way it shoud. I
have studied template online tutorials etc. Could not find a
solution. Can any one help?
--
Wllem Nel


"RichardB43" wrote:

"Suzanne S. Barnhill" wrote:

This isn't any different from previous versions, is it?

Like everything else in the new version (I've used it maybe 1
year now,
still find it abysmal for navigation), it is a hell of a lot
harder to find.

And even try searching for "formula" in help - nothing!

Lots of fancy stuff in the new version about making your
document look pretty, but as for useability, it was a huge
retrograde step!



  #12  
Old June 4th, 2009, 03:05 PM posted to microsoft.public.word.tables
Willem Nel
external usenet poster
 
Posts: 12
Default Getting a table to total columns

THANK YOU VERY MUCH TO ALL WHO HAD AN INPUT! ONE VERY HAPPY CUSTOMER! MAY
YOUR INPUTS BE REWARDED!
--
Wllem Nel


"Graham Mayor" wrote:

In that case plan B. Replace the calculated formfield with a conditional
field. If the field bookmark names remain A1 & A2

{ IF{ ={ A1 } * { A2 } } 0 { ={ A1 } * { A2 } \# "0.00"} }

Set the switch \# "0.00" appropriate to your needs
The field will show a syntax error if there is no value in A1 or A2, so set
those field types to number and put a default 0 in each.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Willem Nel wrote:
Thanks Doug!!! Form calculations now running smooth! Need one more
input from you, please. How do I get the result of a calculation to
not show 0. I want the field to be blank if result is 0.



Insert Text Input FormFields in A1 and A2 and set the Calculate on
Exit property of each. Assuming that you name bookmarks assigned to
those fields as A1 and a2, in A3, insert a calculation type
formfield that contains the expression =A1 * A2

See the following;

http://www.mousetrax.com/techpage.html#autoforms
Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and
keep better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Willem Nel" wrote in message
...
In tables in word:

A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2
All formulas work is template mode if number in A1 AND A2 is
recorded when formula is set. There after ctrl+a, f9 updates field
in template. If template
is protected or saved as word document A3 never changes when A1 OR
A2 changes. Ctrl+a, F9 or right click also does not work. Form with
calculation
of no use to customers or our company! Need to get A3 formula to
automaticly
update when A1 OR A2 changes if template is protected or saved as
word document. See book-keeping slip template under forms on online
templates. This is what formulas should do! Book-keeping slip is
protected and cannot see formula!

--
Wllem Nel


"Doug Robbins - Word MVP" wrote:

Can you provide more details of what you want to do?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of
my services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Willem Nel" wrote in message
...
Ctrl+A, F9 works in template (not protected). When the form is
with a customer or user no formulas operates the way it shoud. I
have studied template online tutorials etc. Could not find a
solution. Can any one help?
--
Wllem Nel


"RichardB43" wrote:

"Suzanne S. Barnhill" wrote:

This isn't any different from previous versions, is it?

Like everything else in the new version (I've used it maybe 1
year now,
still find it abysmal for navigation), it is a hell of a lot
harder to find.

And even try searching for "formula" in help - nothing!

Lots of fancy stuff in the new version about making your
document look pretty, but as for useability, it was a huge
retrograde step!




  #13  
Old June 4th, 2009, 05:57 PM posted to microsoft.public.word.tables
Willem Nel
external usenet poster
 
Posts: 12
Default Getting a table to total columns

Back again. Where do I find conditional field.
--
Wllem Nel


"Willem Nel" wrote:

THANK YOU VERY MUCH TO ALL WHO HAD AN INPUT! ONE VERY HAPPY CUSTOMER! MAY
YOUR INPUTS BE REWARDED!
--
Wllem Nel


"Graham Mayor" wrote:

In that case plan B. Replace the calculated formfield with a conditional
field. If the field bookmark names remain A1 & A2

{ IF{ ={ A1 } * { A2 } } 0 { ={ A1 } * { A2 } \# "0.00"} }

Set the switch \# "0.00" appropriate to your needs
The field will show a syntax error if there is no value in A1 or A2, so set
those field types to number and put a default 0 in each.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Willem Nel wrote:
Thanks Doug!!! Form calculations now running smooth! Need one more
input from you, please. How do I get the result of a calculation to
not show 0. I want the field to be blank if result is 0.



Insert Text Input FormFields in A1 and A2 and set the Calculate on
Exit property of each. Assuming that you name bookmarks assigned to
those fields as A1 and a2, in A3, insert a calculation type
formfield that contains the expression =A1 * A2

See the following;

http://www.mousetrax.com/techpage.html#autoforms
Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and
keep better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Willem Nel" wrote in message
...
In tables in word:

A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2
All formulas work is template mode if number in A1 AND A2 is
recorded when formula is set. There after ctrl+a, f9 updates field
in template. If template
is protected or saved as word document A3 never changes when A1 OR
A2 changes. Ctrl+a, F9 or right click also does not work. Form with
calculation
of no use to customers or our company! Need to get A3 formula to
automaticly
update when A1 OR A2 changes if template is protected or saved as
word document. See book-keeping slip template under forms on online
templates. This is what formulas should do! Book-keeping slip is
protected and cannot see formula!

--
Wllem Nel


"Doug Robbins - Word MVP" wrote:

Can you provide more details of what you want to do?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of
my services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Willem Nel" wrote in message
...
Ctrl+A, F9 works in template (not protected). When the form is
with a customer or user no formulas operates the way it shoud. I
have studied template online tutorials etc. Could not find a
solution. Can any one help?
--
Wllem Nel


"RichardB43" wrote:

"Suzanne S. Barnhill" wrote:

This isn't any different from previous versions, is it?

Like everything else in the new version (I've used it maybe 1
year now,
still find it abysmal for navigation), it is a hell of a lot
harder to find.

And even try searching for "formula" in help - nothing!

Lots of fancy stuff in the new version about making your
document look pretty, but as for useability, it was a huge
retrograde step!




  #14  
Old June 4th, 2009, 06:48 PM posted to microsoft.public.word.tables
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
Default Getting a table to total columns

The IF field is the conditional field. Graham has provided the required
syntax.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Willem Nel" wrote in message
...
Back again. Where do I find conditional field.
--
Wllem Nel


"Willem Nel" wrote:

THANK YOU VERY MUCH TO ALL WHO HAD AN INPUT! ONE VERY HAPPY CUSTOMER! MAY
YOUR INPUTS BE REWARDED!
--
Wllem Nel


"Graham Mayor" wrote:

In that case plan B. Replace the calculated formfield with a
conditional
field. If the field bookmark names remain A1 & A2

{ IF{ ={ A1 } * { A2 } } 0 { ={ A1 } * { A2 } \# "0.00"} }

Set the switch \# "0.00" appropriate to your needs
The field will show a syntax error if there is no value in A1 or A2, so
set
those field types to number and put a default 0 in each.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Willem Nel wrote:
Thanks Doug!!! Form calculations now running smooth! Need one more
input from you, please. How do I get the result of a calculation to
not show 0. I want the field to be blank if result is 0.



Insert Text Input FormFields in A1 and A2 and set the Calculate on
Exit property of each. Assuming that you name bookmarks assigned to
those fields as A1 and a2, in A3, insert a calculation type
formfield that contains the expression =A1 * A2

See the following;

http://www.mousetrax.com/techpage.html#autoforms
Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and
keep better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of
my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Willem Nel" wrote in message
...
In tables in word:

A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2
All formulas work is template mode if number in A1 AND A2 is
recorded when formula is set. There after ctrl+a, f9 updates field
in template. If template
is protected or saved as word document A3 never changes when A1 OR
A2 changes. Ctrl+a, F9 or right click also does not work. Form with
calculation
of no use to customers or our company! Need to get A3 formula to
automaticly
update when A1 OR A2 changes if template is protected or saved as
word document. See book-keeping slip template under forms on online
templates. This is what formulas should do! Book-keeping slip is
protected and cannot see formula!

--
Wllem Nel


"Doug Robbins - Word MVP" wrote:

Can you provide more details of what you want to do?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of
my services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via
msnews.microsoft.com
"Willem Nel" wrote in message
...
Ctrl+A, F9 works in template (not protected). When the form is
with a customer or user no formulas operates the way it shoud. I
have studied template online tutorials etc. Could not find a
solution. Can any one help?
--
Wllem Nel


"RichardB43" wrote:

"Suzanne S. Barnhill" wrote:

This isn't any different from previous versions, is it?

Like everything else in the new version (I've used it maybe 1
year now,
still find it abysmal for navigation), it is a hell of a lot
harder to find.

And even try searching for "formula" in help - nothing!

Lots of fancy stuff in the new version about making your
document look pretty, but as for useability, it was a huge
retrograde step!





  #15  
Old June 4th, 2009, 07:25 PM posted to microsoft.public.word.tables
Willem Nel
external usenet poster
 
Posts: 12
Default Getting a table to total columns

I used text form field, calculation, =text1*text2. Can you give me the
complete expression to use (in text form field?) for calculation, =text 1 and
for =text1*text2 to avoid the 0 from showing. Please, this is the last
hurdle. You guys have been very helpfull. Thanks a milion
--
Wllem Nel


"Suzanne S. Barnhill" wrote:

The IF field is the conditional field. Graham has provided the required
syntax.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Willem Nel" wrote in message
...
Back again. Where do I find conditional field.
--
Wllem Nel


"Willem Nel" wrote:

THANK YOU VERY MUCH TO ALL WHO HAD AN INPUT! ONE VERY HAPPY CUSTOMER! MAY
YOUR INPUTS BE REWARDED!
--
Wllem Nel


"Graham Mayor" wrote:

In that case plan B. Replace the calculated formfield with a
conditional
field. If the field bookmark names remain A1 & A2

{ IF{ ={ A1 } * { A2 } } 0 { ={ A1 } * { A2 } \# "0.00"} }

Set the switch \# "0.00" appropriate to your needs
The field will show a syntax error if there is no value in A1 or A2, so
set
those field types to number and put a default 0 in each.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Willem Nel wrote:
Thanks Doug!!! Form calculations now running smooth! Need one more
input from you, please. How do I get the result of a calculation to
not show 0. I want the field to be blank if result is 0.



Insert Text Input FormFields in A1 and A2 and set the Calculate on
Exit property of each. Assuming that you name bookmarks assigned to
those fields as A1 and a2, in A3, insert a calculation type
formfield that contains the expression =A1 * A2

See the following;

http://www.mousetrax.com/techpage.html#autoforms
Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and
keep better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of
my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Willem Nel" wrote in message
...
In tables in word:

A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2
All formulas work is template mode if number in A1 AND A2 is
recorded when formula is set. There after ctrl+a, f9 updates field
in template. If template
is protected or saved as word document A3 never changes when A1 OR
A2 changes. Ctrl+a, F9 or right click also does not work. Form with
calculation
of no use to customers or our company! Need to get A3 formula to
automaticly
update when A1 OR A2 changes if template is protected or saved as
word document. See book-keeping slip template under forms on online
templates. This is what formulas should do! Book-keeping slip is
protected and cannot see formula!

--
Wllem Nel


"Doug Robbins - Word MVP" wrote:

Can you provide more details of what you want to do?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of
my services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via
msnews.microsoft.com
"Willem Nel" wrote in message
...
Ctrl+A, F9 works in template (not protected). When the form is
with a customer or user no formulas operates the way it shoud. I
have studied template online tutorials etc. Could not find a
solution. Can any one help?
--
Wllem Nel


"RichardB43" wrote:

"Suzanne S. Barnhill" wrote:

This isn't any different from previous versions, is it?

Like everything else in the new version (I've used it maybe 1
year now,
still find it abysmal for navigation), it is a hell of a lot
harder to find.

And even try searching for "formula" in help - nothing!

Lots of fancy stuff in the new version about making your
document look pretty, but as for useability, it was a huge
retrograde step!






  #16  
Old June 4th, 2009, 09:46 PM posted to microsoft.public.word.tables
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
Default Getting a table to total columns

Instead of using a text form field, you must insert the field code as Graham
gave it. Each pair of field delimiters (the things that look like braces but
can't be entered from the keyboard) must be inserted using Ctrl+F9.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Willem Nel" wrote in message
...
I used text form field, calculation, =text1*text2. Can you give me the
complete expression to use (in text form field?) for calculation, =text 1
and
for =text1*text2 to avoid the 0 from showing. Please, this is the last
hurdle. You guys have been very helpfull. Thanks a milion
--
Wllem Nel


"Suzanne S. Barnhill" wrote:

The IF field is the conditional field. Graham has provided the required
syntax.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Willem Nel" wrote in message
...
Back again. Where do I find conditional field.
--
Wllem Nel


"Willem Nel" wrote:

THANK YOU VERY MUCH TO ALL WHO HAD AN INPUT! ONE VERY HAPPY CUSTOMER!
MAY
YOUR INPUTS BE REWARDED!
--
Wllem Nel


"Graham Mayor" wrote:

In that case plan B. Replace the calculated formfield with a
conditional
field. If the field bookmark names remain A1 & A2

{ IF{ ={ A1 } * { A2 } } 0 { ={ A1 } * { A2 } \# "0.00"} }

Set the switch \# "0.00" appropriate to your needs
The field will show a syntax error if there is no value in A1 or A2,
so
set
those field types to number and put a default 0 in each.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Willem Nel wrote:
Thanks Doug!!! Form calculations now running smooth! Need one more
input from you, please. How do I get the result of a calculation
to
not show 0. I want the field to be blank if result is 0.



Insert Text Input FormFields in A1 and A2 and set the Calculate
on
Exit property of each. Assuming that you name bookmarks assigned
to
those fields as A1 and a2, in A3, insert a calculation type
formfield that contains the expression =A1 * A2

See the following;

http://www.mousetrax.com/techpage.html#autoforms
Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time
and
keep better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself
of
my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via
msnews.microsoft.com
"Willem Nel" wrote in message
...
In tables in word:

A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2
All formulas work is template mode if number in A1 AND A2 is
recorded when formula is set. There after ctrl+a, f9 updates
field
in template. If template
is protected or saved as word document A3 never changes when A1
OR
A2 changes. Ctrl+a, F9 or right click also does not work. Form
with
calculation
of no use to customers or our company! Need to get A3 formula to
automaticly
update when A1 OR A2 changes if template is protected or saved
as
word document. See book-keeping slip template under forms on
online
templates. This is what formulas should do! Book-keeping slip is
protected and cannot see formula!

--
Wllem Nel


"Doug Robbins - Word MVP" wrote:

Can you provide more details of what you want to do?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself
of
my services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via
msnews.microsoft.com
"Willem Nel" wrote in message
...
Ctrl+A, F9 works in template (not protected). When the form is
with a customer or user no formulas operates the way it shoud.
I
have studied template online tutorials etc. Could not find a
solution. Can any one help?
--
Wllem Nel


"RichardB43" wrote:

"Suzanne S. Barnhill" wrote:

This isn't any different from previous versions, is it?

Like everything else in the new version (I've used it maybe 1
year now,
still find it abysmal for navigation), it is a hell of a lot
harder to find.

And even try searching for "formula" in help - nothing!

Lots of fancy stuff in the new version about making your
document look pretty, but as for useability, it was a huge
retrograde step!








  #17  
Old June 4th, 2009, 11:03 PM posted to microsoft.public.word.tables
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Getting a table to total columns

With the document unprotected, press Alt+F9 to toggle the display of the
field codes and modify the calculation field to the following

{ FORMTEXT { =A1 * A2 } \# 0;-0; }

You can replace the 0 with whatever format you require for the result

e.g. 0.00;(0.00);

etc.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Willem Nel" wrote in message
...
Thanks Doug!!! Form calculations now running smooth! Need one more input
from
you, please. How do I get the result of a calculation to not show 0. I
want
the field to be blank if result is 0.


--
Wllem Nel


"Doug Robbins - Word MVP" wrote:

Insert Text Input FormFields in A1 and A2 and set the Calculate on Exit
property of each. Assuming that you name bookmarks assigned to those
fields
as A1 and a2, in A3, insert a calculation type formfield that contains
the
expression =A1 * A2

See the following;

http://www.mousetrax.com/techpage.html#autoforms
Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and keep
better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Willem Nel" wrote in message
...
In tables in word:

A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2
All formulas work is template mode if number in A1 AND A2 is recorded
when
formula is set. There after ctrl+a, f9 updates field in template. If
template
is protected or saved as word document A3 never changes when A1 OR A2
changes. Ctrl+a, F9 or right click also does not work. Form with
calculation
of no use to customers or our company! Need to get A3 formula to
automaticly
update when A1 OR A2 changes if template is protected or saved as word
document. See book-keeping slip template under forms on online
templates.
This is what formulas should do! Book-keeping slip is protected and
cannot
see formula!

--
Wllem Nel


"Doug Robbins - Word MVP" wrote:

Can you provide more details of what you want to do?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Willem Nel" wrote in message
...
Ctrl+A, F9 works in template (not protected). When the form is with
a
customer or user no formulas operates the way it shoud. I have
studied
template online tutorials etc. Could not find a solution. Can any
one
help?
--
Wllem Nel


"RichardB43" wrote:

"Suzanne S. Barnhill" wrote:

This isn't any different from previous versions, is it?

Like everything else in the new version (I've used it maybe 1 year
now,
still find it abysmal for navigation), it is a hell of a lot harder
to
find.

And even try searching for "formula" in help - nothing!

Lots of fancy stuff in the new version about making your document
look
pretty, but as for useability, it was a huge retrograde step!





  #18  
Old June 5th, 2009, 09:24 AM posted to microsoft.public.word.tables
Willem Nel
external usenet poster
 
Posts: 12
Default Getting a table to total columns

Thanks for taking the time and the effort to help me. I must be doing
something wrong. I changed the field code with alt f9 and enterd the text
code you gave me as it is. I still get the 0. Can I email the doc to you to
save us both time and effort or can you do a table with 3 coloms with text
field form, text1 and text2 is a number with format 0 and text3 is a
calculation with format # ##0 (i also tried 0) and email it to me.

I need to change this so that text3 do not display the result of the
calculation if it is is 0.

I will keep trying till I get it right or untill I here from you. I truely
appreciate your inputs and realise that you might get frustrated with my
inability to get it wright. Therefore the suggestion I email the doc to you
or you do a sample as described above and email that to me so I can see what
I am doing wrong.
Is there a way to add an atttachment to this message?

I need to solve this before 08h00 on 06/06/2009 (South-african time)

My e-mail adress is


--
Wllem Nel


"Willem Nel" wrote:

I used text form field, calculation, =text1*text2. Can you give me the
complete expression to use (in text form field?) for calculation, =text 1 and
for =text1*text2 to avoid the 0 from showing. Please, this is the last
hurdle. You guys have been very helpfull. Thanks a milion
--
Wllem Nel


"Suzanne S. Barnhill" wrote:

The IF field is the conditional field. Graham has provided the required
syntax.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Willem Nel" wrote in message
...
Back again. Where do I find conditional field.
--
Wllem Nel


"Willem Nel" wrote:

THANK YOU VERY MUCH TO ALL WHO HAD AN INPUT! ONE VERY HAPPY CUSTOMER! MAY
YOUR INPUTS BE REWARDED!
--
Wllem Nel


"Graham Mayor" wrote:

In that case plan B. Replace the calculated formfield with a
conditional
field. If the field bookmark names remain A1 & A2

{ IF{ ={ A1 } * { A2 } } 0 { ={ A1 } * { A2 } \# "0.00"} }

Set the switch \# "0.00" appropriate to your needs
The field will show a syntax error if there is no value in A1 or A2, so
set
those field types to number and put a default 0 in each.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Willem Nel wrote:
Thanks Doug!!! Form calculations now running smooth! Need one more
input from you, please. How do I get the result of a calculation to
not show 0. I want the field to be blank if result is 0.



Insert Text Input FormFields in A1 and A2 and set the Calculate on
Exit property of each. Assuming that you name bookmarks assigned to
those fields as A1 and a2, in A3, insert a calculation type
formfield that contains the expression =A1 * A2

See the following;

http://www.mousetrax.com/techpage.html#autoforms
Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and
keep better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of
my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Willem Nel" wrote in message
...
In tables in word:

A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2
All formulas work is template mode if number in A1 AND A2 is
recorded when formula is set. There after ctrl+a, f9 updates field
in template. If template
is protected or saved as word document A3 never changes when A1 OR
A2 changes. Ctrl+a, F9 or right click also does not work. Form with
calculation
of no use to customers or our company! Need to get A3 formula to
automaticly
update when A1 OR A2 changes if template is protected or saved as
word document. See book-keeping slip template under forms on online
templates. This is what formulas should do! Book-keeping slip is
protected and cannot see formula!

--
Wllem Nel


"Doug Robbins - Word MVP" wrote:

Can you provide more details of what you want to do?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of
my services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via
msnews.microsoft.com
"Willem Nel" wrote in message
...
Ctrl+A, F9 works in template (not protected). When the form is
with a customer or user no formulas operates the way it shoud. I
have studied template online tutorials etc. Could not find a
solution. Can any one help?
--
Wllem Nel


"RichardB43" wrote:

"Suzanne S. Barnhill" wrote:

This isn't any different from previous versions, is it?

Like everything else in the new version (I've used it maybe 1
year now,
still find it abysmal for navigation), it is a hell of a lot
harder to find.

And even try searching for "formula" in help - nothing!

Lots of fancy stuff in the new version about making your
document look pretty, but as for useability, it was a huge
retrograde step!






  #19  
Old June 5th, 2009, 02:21 PM posted to microsoft.public.word.tables
Graham Mayor
external usenet poster
 
Posts: 18,297
Default Getting a table to total columns

Send it to the link on the home page of my web site.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Willem Nel wrote:
Thanks for taking the time and the effort to help me. I must be doing
something wrong. I changed the field code with alt f9 and enterd the
text code you gave me as it is. I still get the 0. Can I email the
doc to you to save us both time and effort or can you do a table with
3 coloms with text field form, text1 and text2 is a number with
format 0 and text3 is a calculation with format # ##0 (i also tried
0) and email it to me.

I need to change this so that text3 do not display the result of the
calculation if it is is 0.

I will keep trying till I get it right or untill I here from you. I
truely appreciate your inputs and realise that you might get
frustrated with my inability to get it wright. Therefore the
suggestion I email the doc to you or you do a sample as described
above and email that to me so I can see what I am doing wrong.
Is there a way to add an atttachment to this message?

I need to solve this before 08h00 on 06/06/2009 (South-african time)

My e-mail adress is



I used text form field, calculation, =text1*text2. Can you give me
the complete expression to use (in text form field?) for
calculation, =text 1 and for =text1*text2 to avoid the 0 from
showing. Please, this is the last hurdle. You guys have been very
helpfull. Thanks a milion --
Wllem Nel


"Suzanne S. Barnhill" wrote:

The IF field is the conditional field. Graham has provided the
required syntax.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Willem Nel" wrote in message
...
Back again. Where do I find conditional field.
--
Wllem Nel


"Willem Nel" wrote:

THANK YOU VERY MUCH TO ALL WHO HAD AN INPUT! ONE VERY HAPPY
CUSTOMER! MAY YOUR INPUTS BE REWARDED!
--
Wllem Nel


"Graham Mayor" wrote:

In that case plan B. Replace the calculated formfield with a
conditional
field. If the field bookmark names remain A1 & A2

{ IF{ ={ A1 } * { A2 } } 0 { ={ A1 } * { A2 } \# "0.00"} }

Set the switch \# "0.00" appropriate to your needs
The field will show a syntax error if there is no value in A1 or
A2, so set
those field types to number and put a default 0 in each.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Willem Nel wrote:
Thanks Doug!!! Form calculations now running smooth! Need one
more input from you, please. How do I get the result of a
calculation to not show 0. I want the field to be blank if
result is 0.



Insert Text Input FormFields in A1 and A2 and set the
Calculate on Exit property of each. Assuming that you name
bookmarks assigned to those fields as A1 and a2, in A3, insert
a calculation type formfield that contains the expression =A1
* A2

See the following;

http://www.mousetrax.com/techpage.html#autoforms
Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time
and keep better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail
yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via
msnews.microsoft.com "Willem Nel"
wrote in message
...
In tables in word:

A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2
All formulas work is template mode if number in A1 AND A2 is
recorded when formula is set. There after ctrl+a, f9 updates
field in template. If template
is protected or saved as word document A3 never changes when
A1 OR A2 changes. Ctrl+a, F9 or right click also does not
work. Form with calculation
of no use to customers or our company! Need to get A3 formula
to automaticly
update when A1 OR A2 changes if template is protected or
saved as word document. See book-keeping slip template under
forms on online templates. This is what formulas should do!
Book-keeping slip is protected and cannot see formula!

--
Wllem Nel


"Doug Robbins - Word MVP" wrote:

Can you provide more details of what you want to do?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail
yourself of my services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via
msnews.microsoft.com
"Willem Nel" wrote in message
...
Ctrl+A, F9 works in template (not protected). When the form
is with a customer or user no formulas operates the way it
shoud. I have studied template online tutorials etc. Could
not find a solution. Can any one help?
--
Wllem Nel


"RichardB43" wrote:

"Suzanne S. Barnhill" wrote:

This isn't any different from previous versions, is it?

Like everything else in the new version (I've used it
maybe 1 year now,
still find it abysmal for navigation), it is a hell of a
lot harder to find.

And even try searching for "formula" in help - nothing!

Lots of fancy stuff in the new version about making your
document look pretty, but as for useability, it was a huge
retrograde step!



  #20  
Old June 6th, 2009, 12:10 AM posted to microsoft.public.word.tables
Willem Nel
external usenet poster
 
Posts: 12
Default Getting a table to total columns

I found the selution through trial and error.

{ FORMTEXT { =A1 * A2 } \# #;-#; } and not { FORMTEXT { =A1 * A2 } \# 0;-0;
} or the IF option.

Thanks for your inputs. It has helped me to get to the selution, believe it
or not.
--
Wllem Nel


"Doug Robbins - Word MVP" wrote:

With the document unprotected, press Alt+F9 to toggle the display of the
field codes and modify the calculation field to the following

{ FORMTEXT { =A1 * A2 } \# 0;-0; }

You can replace the 0 with whatever format you require for the result

e.g. 0.00;(0.00);

etc.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Willem Nel" wrote in message
...
Thanks Doug!!! Form calculations now running smooth! Need one more input
from
you, please. How do I get the result of a calculation to not show 0. I
want
the field to be blank if result is 0.


--
Wllem Nel


"Doug Robbins - Word MVP" wrote:

Insert Text Input FormFields in A1 and A2 and set the Calculate on Exit
property of each. Assuming that you name bookmarks assigned to those
fields
as A1 and a2, in A3, insert a calculation type formfield that contains
the
expression =A1 * A2

See the following;

http://www.mousetrax.com/techpage.html#autoforms
Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and keep
better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Willem Nel" wrote in message
...
In tables in word:

A1 =2 A2=4 A3= SUM(LEFT) OR A1*A2
All formulas work is template mode if number in A1 AND A2 is recorded
when
formula is set. There after ctrl+a, f9 updates field in template. If
template
is protected or saved as word document A3 never changes when A1 OR A2
changes. Ctrl+a, F9 or right click also does not work. Form with
calculation
of no use to customers or our company! Need to get A3 formula to
automaticly
update when A1 OR A2 changes if template is protected or saved as word
document. See book-keeping slip template under forms on online
templates.
This is what formulas should do! Book-keeping slip is protected and
cannot
see formula!

--
Wllem Nel


"Doug Robbins - Word MVP" wrote:

Can you provide more details of what you want to do?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Willem Nel" wrote in message
...
Ctrl+A, F9 works in template (not protected). When the form is with
a
customer or user no formulas operates the way it shoud. I have
studied
template online tutorials etc. Could not find a solution. Can any
one
help?
--
Wllem Nel


"RichardB43" wrote:

"Suzanne S. Barnhill" wrote:

This isn't any different from previous versions, is it?

Like everything else in the new version (I've used it maybe 1 year
now,
still find it abysmal for navigation), it is a hell of a lot harder
to
find.

And even try searching for "formula" in help - nothing!

Lots of fancy stuff in the new version about making your document
look
pretty, but as for useability, it was a huge retrograde step!






 




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


All times are GMT +1. The time now is 03:32 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.