Calculation on a form

  • Thread starter Thread starter George Wilson
  • Start date Start date
G

George Wilson

I am trying to calculate a quantity * price field on a
form. I am currently using Word XP on a Windows XP system.
I have the field names properly set, but have been unable
to get the sum column to total. For my calculation I have
tried the syntax =price*qty and I have tried =(price)*
(qty) and it is still not doing the calculation. I have
tried with and without the calculate on exit option
checked. Is there something else I need to do to make the
calculation complete? Is the syntax I'm using correct?
TIA
George
 
You need three form fields for this
a price field, and quantity field both with the properties set as numeric
and masks set as appropriate. Ensure that you name the bookmarks price and
quantity. Set the calculate on exit check box on the second of the fields.
You then need a calculated form field with the calculation =price * quantity
and a number mask set as required.
The syntax for this field requires that you use the bookmark names set in
the other two fields (by default these would be text1, text2 etc.
so a calculation of =text1 * text2 may be nearer the mark ;) )

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
 
Back
Top