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

  • Thread starter Thread starter Henri
  • Start date Start date
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
 
Maybe with a Pass Through Query? a PTQ is ignored by Jet, so there's no
error checking.
 
Back
Top