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
I don't have access to the Oracle dB. No pun intended here. Everything I do, I must do from the MS Access 2003 front-end
wow .. that's kinda like sending soldiers into a war zone with a bear trap attached to their legs. O_0
Kind of blatantly trying to hamper your ability to do your job, don't you think?
It has been a long time since I used Access much, but the point of a passthrough query is that Access does not attempt to parse it at all, just passes it along tothe target database. So, just make the whole thing a passthrough query, don't try to query from a passthrough query.