compare memo fields

[Francis]

I have 2 memo fields in table1.field1 and table2.field2. I need to
compare them, and get the rows where the fields arent equal. How can
one accomplish this?
Thanks advance
of
Francis

 

[Arvin Meyer [MVP]]

You can compare the first or last 255 characters by using the Left or Right
functions to extract those characters. To compare the entire memo field, you
may need to copy and paste into a text file and then use something like
ExamDiff to compare them:

http://www.prestosoft.com/ps.asp?page=edp_examdiff
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Francis]

ok

Actually the proggie ExamDiff is handy, and even i won't use it to this
case, is usable when you need to compare different files.i'm testing it
and if i like i may keep it in pc.

Thanks
Francis

Arvin Meyer [MVP] escreveu:

 

[Arvin Meyer [MVP]]

I use it often when coding to compare versions of my code. I simply save
each file as a text file and run ExamDiff.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com