Superscripts in MS Access

[dbadmin]

Hi Gurus,

Is it possible to store a data like x to the power of 2 (x raised to 2) in MS Access? If yes, how?

dbadmin

 

[Blorf]

Can you explain further? Obviously you don't just want to store two values, X and 2.

ChaZ



"When religion and politics ride in the same cart...the whirlwind follows."
Frank Herbert

 

[MoLaker]

I'm not sure how one might do that. Values stored in a database typically represent a specific value and not a computation (as 'x squared' or 'x to the tenth power' implies).

You could store a string ("25^3" or something like that) to represent 25 cubed - as an example. A function could be written to interpret this string and convert it to the calculated value at some point in time.

Function xPower(x As String)
' returns exponential value y raised to z power
' x has to be a string in format of number ^ number (4^2)
' y represents base number
' z represents exponent
    Dim y As Double, z As Integer, i As Integer
    i = InStr(1, x, "^", 1)
    If i = 0 Then Exit Function
    If IsNumeric(Left(x, i - 1)) Then
        y = Left(x, i - 1)
    Else
        Exit Function
    End If
    If IsNumeric(Right(x, Len(x) - i)) Then
        z = Right(x, Len(x) - i)
    Else
        Exit Function
    End If
    xPower = y
    If z = 0 Then
        xPower = 1
        Exit Function
    End If
    For i = 2 To z
        xPower = xPower * y
    Next
End Function

Or something like that.

 

[jsteph]

...or you could just do
xpower = Eval(x)
--Jim

 

[MoLaker]

Sometimes old age catches up with you and you just can't remember everything. How embarassing.

 

[jsteph]

...I've been caught doing the same type of thing myself, and I'm getting to that point where the 'old age' thing is fitting to well.
--Jim