Convert Memo field ?

[Peter]

An Access 97 database is linked to SQL Server via ODBC.

We would like to use SELECT DISTINCT in a query but it
replies that we are not able to do so as there is a memo
field. Is it possible for us to convert the Memo field to
a text field in the query so that we can use DISTINCT
feature ?

Your help is sought.

 

[Joseph Meehan]

An Access 97 database is linked to SQL Server via ODBC.

We would like to use SELECT DISTINCT in a query but it
replies that we are not able to do so as there is a memo
field. Is it possible for us to convert the Memo field to
a text field in the query so that we can use DISTINCT
feature ?

Your help is sought.

If the data will fit in a text field, why don't you just convert it to a
text field in the table and be done with it?

 

[Peter]

Is there any function I can use to convert the Memo field
to a text field ?

Thanks

 

[Joseph Meehan]

Is there any function I can use to convert the Memo field
to a text field ?

Thanks

Do you need to do it programicly? You can just open the table in design
view and change the data type to text. It will warn you that you may loose
data.

I suggest making a copy of your database and make the change then
confirm you data is still there.