Can anyone translate excel formula into access?

[Freud52]

y = 1E-07x6 - 0.0001x5 + 0.0147x4 - 0.635x3 + 12.906x2 - 115.76x + 401.3

this is a formula for a percentile score. the "x" represents th raw score and the number after it is supposed to be superscript (to the power of). the "E" is for scientific notation. Any help would be appreciated. I would like to put it as an event procedure under an on click event under a command button.

[Stang02GT]

y = 1E-07x6 - 0.0001x5 + 0.0147x4 - 0.635x3 + 12.906x2 - 115.76x + 401.3

this is a formula for a percentile score. the "x" represents th raw score and the number after it is supposed to be superscript (to the power of). the "E" is for scientific notation. Any help would be appreciated. I would like to put it as an event procedure under an on click event under a command button.

Freud,

Welcome to the Scripts. I personally am not sure that you can do that, but if you can we have an EXCELLENT Access team/forum here and I would suggest posting your question there.

You can find it by going to the "Forums" section on the blue navigation bar at the top of your screen. Or you can click HERE and it will take you directly to it.

Take care and I hope you get an answer!