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?