Convert Memo field ?

P

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.
 
Top