Changing a string into a mathematical equation

[georgp]

Hi there,

from an Access chart (trendline) I get a STRING (variable) which actually is a mathematical equation, something like
y = 3.624x2 - 2.74x + 6.72.
This string goes into a textbox.
Now I would like to convert the string into a formula, so that with a given y, which comes from another textbox (also as a string) I can determine x.
Any help/hint is welcome.

thanks, georgp

 

[KenReay]

Hi

I think you need to look at the EVal function, in help

This will evaluate an expression. Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[georgp]

Thanks a lot, KenReay - I had surfed through the functions before (incl EVAL) but obviously did not understand its scope. Now I have tried and it worked as expected.
Thanks again, georgp