<div>
use criteria on the grid to join on the first 255 characters of each field<br />
<br />
field --&gt; ProgressStatus255: left([ProgressStatus],255)<wbr /><br />
criteria --&gt; left([otherMemo],255)
</div>


<div>
Perfect, works a treat, thank you very much, especially so quickly
</div>


<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
I am building a bolt on Access tool that takes data from a third party app via an odbc connection. One of the fields I need to join from the app is a long text field ([ProgressStatus]) so whenever I try to join it to another field I keep getting and error message saying you can't join memo fields.<br />
<br />
I think I need to convert it to short text so I can join it to other fields - how can I do this in a &nbsp;query? - a screen shot of the source table is attached &amp;&nbsp;shows the properties of that field<br />
<br />
Can anybody help?<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/01_w04/1073102/Capture.PNG" target="_blank" title="Source App Field Description (25 KB)"><img alt="Source App Field Description" class="file-block lazyload" style="max-width: 470px;" data-src="https://filedb.experts-exchange.com/incoming/2016/01_w04/1073102/Capture.PNG" /></a>
</div>
</div>


Capture.PNG

Dear Experts,

I am building a bolt on Access tool that takes data from a third party app via an odbc connection. One of the fields I need to join from the app is a long text field ([ProgressStatus]) so whenever I try to join it to another field I keep getting and error message saying you can't join memo fields.

I think I need to convert it to short text so I can join it to other fields - how can I do this in a  query? - a screen shot of the source table is attached & shows the properties of that field

Can anybody help?



Convert memo field to short text

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.