built in functions

[tlclear]

There are functions in Excel that I cannot find in Access. Specifically, I am looking for SQRT and ATAN2. Does anyone have any suggestions as to how I can get these and any other available functions to an option from the built-in functions?

Thanks

 

[Norie]

You could create user-defined functions.

e.g.

Public Function SQRT(x)
    SQRT = Sqr(x)
End Function

Not ideal I know but maybe somebody knows better

 

[blueshark]

sqr works in the query grid for square roots