Trying Understand Formulas In Tables

[Bill Bradshaw]

If I enter in the cell

{REF HaulHours} I get the right result.

If I enter in the cell {={REF HaulHours}*10}

I get the syntax error !Syntax Error,*

I am using control F9 to create the braces.

This is starting to drive me nuts.

I hope somebody can save my sanity.

Bill

 

[macropod]

Hi Bill,

Try:
{={HaulHours}*10}

For more information on field-based calculations in Word, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party

Cheers

 

[Bill Bradshaw]

Tried it and I still got the error, !Syntax Error,*. For some reason it does
not want to multiply. I protected the form and entered the data to be used
in the formula. I then unprotected the form and performed a shift-F9 on the
formula and the variable value for HaulHours is correct. It just does not
want to multiply by 10. At some point I will replace the 10 with an hourly
labor costs value if the multiplication will ever work. All the other
multiplication formulas in the form work fine. What I am wanting to do
appears to be so simple I do not know where to start debugging it. I will
appreciate any further help or suggestions I get.

I do not know if this makes a difference but it is Word 2003 running on
WinXP Pro SP2 with all current updates.

<Bill>

Hi Bill,

Try:
{={HaulHours}*10}

For more information on field-based calculations in Word, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

If I enter in the cell

{REF HaulHours} I get the right result.

If I enter in the cell {={REF HaulHours}*10}

I get the syntax error !Syntax Error,*

I am using control F9 to create the braces.

This is starting to drive me nuts.

I hope somebody can save my sanity.

Bill

 

[macropod]

Hi Bill,

Are you sure there are no other characters in the field?

What happens if you use a formula field (not a form field) coded as:
{=HaulHours*10}

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

Tried it and I still got the error, !Syntax Error,*. For some reason it does
not want to multiply. I protected the form and entered the data to be used
in the formula. I then unprotected the form and performed a shift-F9 on the
formula and the variable value for HaulHours is correct. It just does not
want to multiply by 10. At some point I will replace the 10 with an hourly
labor costs value if the multiplication will ever work. All the other
multiplication formulas in the form work fine. What I am wanting to do
appears to be so simple I do not know where to start debugging it. I will
appreciate any further help or suggestions I get.

I do not know if this makes a difference but it is Word 2003 running on
WinXP Pro SP2 with all current updates.

<Bill>

Hi Bill,

Try:
{={HaulHours}*10}

For more information on field-based calculations in Word, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

If I enter in the cell

{REF HaulHours} I get the right result.

If I enter in the cell {={REF HaulHours}*10}

I get the syntax error !Syntax Error,*

I am using control F9 to create the braces.

This is starting to drive me nuts.

I hope somebody can save my sanity.

Bill

 

[Bill Bradshaw]

That gets rid of the syntax error but introduces another error. The haul
hours should be 137 and that is what is calculated for the HaulHours
bookmark. But in the formula written as you showed it HaulHours becomes
100493.1. The only way I have found I can get the right variable amount for
the HaulHours I want to use in the calculation is to REF it. Of course when
I REF it and then try to multiply by 10 I get the syntax error.

What is confusing is why does the form assign wrong 100493.1 to the non REF
HaulHours bookmark and the correct 137 HaulHours when I REF it. Of course
when I REF it I am back to the syntax error problem.

<Bill>

Hi Bill,

Are you sure there are no other characters in the field?

What happens if you use a formula field (not a form field) coded as:
{=HaulHours*10}

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

Tried it and I still got the error, !Syntax Error,*. For some reason it does
not want to multiply. I protected the form and entered the data to be used
in the formula. I then unprotected the form and performed a shift-F9 on the
formula and the variable value for HaulHours is correct. It just does not
want to multiply by 10. At some point I will replace the 10 with an hourly
labor costs value if the multiplication will ever work. All the other
multiplication formulas in the form work fine. What I am wanting to do
appears to be so simple I do not know where to start debugging it. I will
appreciate any further help or suggestions I get.

I do not know if this makes a difference but it is Word 2003 running on
WinXP Pro SP2 with all current updates.

<Bill>

Hi Bill,

Try:
{={HaulHours}*10}

For more information on field-based calculations in Word, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

If I enter in the cell

{REF HaulHours} I get the right result.

If I enter in the cell {={REF HaulHours}*10}

I get the syntax error !Syntax Error,*

I am using control F9 to create the braces.

This is starting to drive me nuts.

I hope somebody can save my sanity.

Bill

 

[macropod]

Hi Bill,

Are you sure there are no other characters in the field?

What happens if you use a formula field (not a form field) coded as:
{=HaulHours}
(ie no multiplication)
and
{=HaulHours*1}

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

That gets rid of the syntax error but introduces another error. The haul
hours should be 137 and that is what is calculated for the HaulHours
bookmark. But in the formula written as you showed it HaulHours becomes
100493.1. The only way I have found I can get the right variable amount for
the HaulHours I want to use in the calculation is to REF it. Of course when
I REF it and then try to multiply by 10 I get the syntax error.

What is confusing is why does the form assign wrong 100493.1 to the non REF
HaulHours bookmark and the correct 137 HaulHours when I REF it. Of course
when I REF it I am back to the syntax error problem.

<Bill>

Hi Bill,

Are you sure there are no other characters in the field?

What happens if you use a formula field (not a form field) coded as:
{=HaulHours*10}

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

Tried it and I still got the error, !Syntax Error,*. For some reason it does
not want to multiply. I protected the form and entered the data to be used
in the formula. I then unprotected the form and performed a shift-F9 on the
formula and the variable value for HaulHours is correct. It just does not
want to multiply by 10. At some point I will replace the 10 with an hourly
labor costs value if the multiplication will ever work. All the other
multiplication formulas in the form work fine. What I am wanting to do
appears to be so simple I do not know where to start debugging it. I will
appreciate any further help or suggestions I get.

I do not know if this makes a difference but it is Word 2003 running on
WinXP Pro SP2 with all current updates.

<Bill>

:

Hi Bill,

Try:
{={HaulHours}*10}

For more information on field-based calculations in Word, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

If I enter in the cell

{REF HaulHours} I get the right result.

If I enter in the cell {={REF HaulHours}*10}

I get the syntax error !Syntax Error,*

I am using control F9 to create the braces.

This is starting to drive me nuts.

I hope somebody can save my sanity.

Bill

 

[Bill Bradshaw]

I did not really understand how bookmarks worked so I was pretty dumb. I was
selecting the entire cell when setting the bookmark instead of just the
formula. Everything is working. Sorry I put you through this.

<Bill>

Hi Bill,

Are you sure there are no other characters in the field?

What happens if you use a formula field (not a form field) coded as:
{=HaulHours}
(ie no multiplication)
and
{=HaulHours*1}

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

That gets rid of the syntax error but introduces another error. The haul
hours should be 137 and that is what is calculated for the HaulHours
bookmark. But in the formula written as you showed it HaulHours becomes
100493.1. The only way I have found I can get the right variable amount for
the HaulHours I want to use in the calculation is to REF it. Of course when
I REF it and then try to multiply by 10 I get the syntax error.

What is confusing is why does the form assign wrong 100493.1 to the non REF
HaulHours bookmark and the correct 137 HaulHours when I REF it. Of course
when I REF it I am back to the syntax error problem.

<Bill>

Hi Bill,

Are you sure there are no other characters in the field?

What happens if you use a formula field (not a form field) coded as:
{=HaulHours*10}

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

Tried it and I still got the error, !Syntax Error,*. For some reason it does
not want to multiply. I protected the form and entered the data to be used
in the formula. I then unprotected the form and performed a shift-F9 on the
formula and the variable value for HaulHours is correct. It just does not
want to multiply by 10. At some point I will replace the 10 with an hourly
labor costs value if the multiplication will ever work. All the other
multiplication formulas in the form work fine. What I am wanting to do
appears to be so simple I do not know where to start debugging it. I will
appreciate any further help or suggestions I get.

I do not know if this makes a difference but it is Word 2003 running on
WinXP Pro SP2 with all current updates.

<Bill>

:

Hi Bill,

Try:
{={HaulHours}*10}

For more information on field-based calculations in Word, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

If I enter in the cell

{REF HaulHours} I get the right result.

If I enter in the cell {={REF HaulHours}*10}

I get the syntax error !Syntax Error,*

I am using control F9 to create the braces.

This is starting to drive me nuts.

I hope somebody can save my sanity.

Bill