compare on a memo field?

H

Harry

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

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


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

insert memo feild into a memo field truncates at 255 characters - 4
cut and paste from a combo box into a memo field 10
#Delete Mark in Bound Memo filed 3
Scanning Through "Memo" Field Is Very Slow 5
adding/changing a memo field as Rich Text 0
Memo Help Box 2
#Delete appear in field 4
"#Delete" in memo field 3

Top