Convert memo field to short text

correlate used Ask the Experts™
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?

Source App Field Description
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016

pls try

select left(myColumn,255) 
 from myTable

Open in new window

crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015

use criteria on the grid to join on the first 255 characters of each field

field --> ProgressStatus255: left([ProgressStatus],255)
criteria --> left([otherMemo],255)


Perfect, works a treat, thank you very much, especially so quickly

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial