Tom Crowfoot
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect, works a treat, thank you very much, especially so quickly
field --> ProgressStatus255: left([ProgressStatus],255)
criteria --> left([otherMemo],255)