POWER function in microsoft access 1

[mekesse]

I am trying to create a formula field in a query that requires me to raise a number to a specified exponent. In excel, I can use a POWER function (e.g. POWER(10,2)=100). however, i cannot find a comparable function in Access. I am using Access 2000 and need a way to be able to use an exponent in a formula.

Does anyone know if this is possible and, if so, how to do it?

Thanks!

Michael

 

[Terpsfan]

The caret character gives you exponentiation. ie 5 ^ 2 = 25

 

[cheerio]

The simplest ways are the best and I would agree with the previous suggestion to use ^

As it happens, on a recent thread (thread701-771134)in this forum under the subject of Conditional Rounding I explained how to incorporate an Excel function into an Access database.

 

[mekesse]

That did the trick! Thanks so much for your fast response!