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
Harry said:
Is it possible to compare on a memo field to identify duplicates? Can
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
