4 Replies Latest reply on Jul 26, 2013 8:07 PM by John Spencer

    Use of LEFT, MID  functions in MS Access expression evaluating a SQL pass-thru on an Oracle Backend


      As the title above suggests this is a somewhat complex problem.

      I have the following expression on a field in a MS Access Make Table query.


      Left([SYN4_View Invalid Last Candidates]![LastName],3). The table it is referring to: SYN4_View Invalid Last Candidates is a SQL Pass-thru query on an Oracle backend. So, when the expression attempts to evaluate in MS Access 2003 I get the following error msg:

      Undefined function 'left' in expression.


      I am assuming this is because LEFT function can't evaluate the output of the SQL P-T. I can't use SUBSTR as Access doesn't recognize it.


      I would appreciate suggestions