Avatar of Tom Crowfoot
Tom Crowfoot
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

Convert memo field to short text

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
Microsoft Access

Avatar of undefined
Last Comment
Tom Crowfoot

8/22/2022 - Mon