Memo field convert to text

[alectek]

Hi!
I need to convert Memo field to text field, using Query.
The function {fn CONVERT (table1."field1", SQL_CHAR} returnig the Error.

Thanks a lot.
Al

 

[dhookom]

This is an Access Reports forum. I'm not sure how/if your question applies.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[alectek]

Duane,

I need this to change data in AAccess Table to use it in Reports....


thanks.
Al.

 

[dhookom]

There is generally no need to convert Access data to anything in order to display it in a report.
Is the data from an Access table?
Have you tried just dragging the field from the field list onto the report?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[alectek]

Duane,
yes the Data in the Access table, but I gonna use it in Crystal Report.
In one of the formulas I need use those memo fields.

Thanks.
Al

 

[dhookom]

Your question has nothing to do with Access reports. You need to find a Crystal Reports forum.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.