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?
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.