<div>
<div class="content wysiwyg-content">
hi<br />
I'm trying to do a query with left(field,1) function and get &quot;undefined function 'left' in expression&quot; error.<br />
<br />
but !!! running the same function in another database, on the same table (linked) brings the results<br />
<br />
why ? 
</div>
</div>


hi
I'm trying to do a query with left(field,1) function and get "undefined function 'left' in expression" error.

but !!! running the same function in another database, on the same table (linked) brings the results

why ? 

undefined function

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.