4 Replies Latest reply: Jul 26, 2013 2:55 PM by Greg Spall RSS

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

    robleh7

      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