compare on a memo field?

[Guest]

Is it possible to compare on a memo field to identify duplicates? Can memo field be joined on? Example if possible. Thank you in advances.

 

[Alex Dybenko]

you can try to convert it to text using left(memo, 255) in a query, then
compare and join
but this is bit strange question, probably something wrong in db design
--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

Is it possible to compare on a memo field to identify duplicates? Can

memo field be joined on? Example if possible. Thank you in advances.

 

[Peter R. Fletcher]

From Access 2000 on, you can sort and/or compare on a memo field in a
query directly, _but_ only the first 255 characters "count" and the
memo fiield that you are using is truncated at that point (as far as
the output of that query is concerned). To do a full comparison of
memo fields, you would have to use VBA code, and it would be horribly
inefficient. As you imply, memo fields are generally used for comments
or free-form text which do not need to be searched or sorted.

you can try to convert it to text using left(memo, 255) in a query, then
compare and join
but this is bit strange question, probably something wrong in db design

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher