AUTOSUM FORM VALUES

[xcavern]

Could someone please give me an example of how to created a new field in a form that calculates another group of forms (adds and subtracts)? Thanks for the help!

 

[ZmrAbdulla]

set controlsource
=[text1]*[text2]

=[text1]+[text2]

=[text1]/[text2]

like this..

If this is not your requirement then tell us the exact one..


________________________________________________________________________
Zameer Abdulla
Visit Me
A person who misses a chance and the monkey who misses its branch can't be saved.

 

[xcavern]

Hi, I need it to add the numbers. Right now if I put "4" in one of the boxes, and "4" in the other, =[text1]+[text2] comes up as "44" I need it to add to "8"

Thanks

 

[PHV]

And this ?
=Val([text1] & "") + Val([text2] & "")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ZmrAbdulla]

You need to change the data type of the field from text to number. Then you can use " =[text1]+[text2] " directly.

________________________________________________________________________
Zameer Abdulla
Visit Me
A person who misses a chance and the monkey who misses its branch can't be saved.