A
Ademar
I have an MS Access database linked to a SQL table. I'm creating a query in
Access that returns a column of type "ntext" with length "16". I'm not sure
what that data type means but it looks to me like a Memo field. The field
name is "ContactInfo". In that field there is chunks of data separated by
double carriage returns. I need to convert those carriage returns into
columns in the query. Is there a SQL Query Function in Access that I can
use to accomplish this? How would I plug it in to the following query:
SELECT dbo__SupportLog.ContactInfo
FROM dbo__SupportLog;
Thanks,
Ademar.
Access that returns a column of type "ntext" with length "16". I'm not sure
what that data type means but it looks to me like a Memo field. The field
name is "ContactInfo". In that field there is chunks of data separated by
double carriage returns. I need to convert those carriage returns into
columns in the query. Is there a SQL Query Function in Access that I can
use to accomplish this? How would I plug it in to the following query:
SELECT dbo__SupportLog.ContactInfo
FROM dbo__SupportLog;
Thanks,
Ademar.