How to use ODBC scalar functions when querying an Access database?

H

Henri

I can't get this kind of query to work:

SELECT {fn POWER(mytable.myfield, 4)} AS myalias FROM mytable

How can I use ODBC scalar functions in Access queries?
I need to do it from Jet 4 also
Thanks for your help

Henri
 
M

[MVP] S.Clark

Maybe with a Pass Through Query? a PTQ is ignored by Jet, so there's no
error checking.
 
Top