This discussion is archived
4 Replies Latest reply: Jul 26, 2013 12: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 Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points