469,332 Members | 6,987 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,332 developers. It's quick & easy.

Compare two fields and to find the look-alike record

Dear reader,

For matching of two fields it is required that the fields has the same
content.

But now I have the situation that two text fields has not precisely the same
content but there is some minute deference.

Now I am looking for a possibility to compare the two fields and to find the
look-alike content of the field.

Is there same code available to do this?

Thanks for any help.

Kind regards,

Simon van Beek

Apr 26 '06 #1
3 5951
Hi, Simon.
But now I have the situation that two text fields has not precisely the
same
content but there is some minute deference.

Now I am looking for a possibility to compare the two fields and to find
the
look-alike content of the field.
I'm not sure I understand your question, but perhaps you are trying to match
fields in a join expression in a query? If so, here are two examples of
doing a join on two similar fields. The last three characters in the Task
field may or may not match the three numbers in the TrainingCode field, so
the Right( ) and CInt( ) methods are used to manipulate the string value in
the Task field:

SELECT *
FROM tblTrainingCodes INNER JOIN tblTasks ON
tblTrainingCodes.TrainingCode = CInt(Right(tblTasks.Task, 3));

A wildcard can be used, as well:

SELECT *
FROM tblTrainingCodes INNER JOIN tblTasks ON
tblTasks.Task LIKE "*" & tblTrainingCodes.TrainingCode;

Much of the time, experimenting with different join expressions in Jet will
reveal an error message of "Join expression not supported."

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Simon" <S.******@HCCnet.nl> wrote in message
news:44**********************@dreader29.news.xs4al l.nl... Dear reader,

For matching of two fields it is required that the fields has the same
content.

But now I have the situation that two text fields has not precisely the
same
content but there is some minute deference.

Now I am looking for a possibility to compare the two fields and to find
the
look-alike content of the field.

Is there same code available to do this?

Thanks for any help.

Kind regards,

Simon van Beek

Apr 27 '06 #2

A couple of weeks ago in this group, there was a posting and a few replies
that did just this. It discussed some algorithms that compared similar
strings and the discussion was about the speed of the algorithm in comparing
large tables.

Unfortunately, I don't have time to look for this right now, but you can try
the archive of this group searching in google.

Bas Hartkamp.
"Simon" <S.******@HCCnet.nl> schreef in bericht
news:44**********************@dreader29.news.xs4al l.nl...
Dear reader,

For matching of two fields it is required that the fields has the same
content.

But now I have the situation that two text fields has not precisely the
same
content but there is some minute deference.

Now I am looking for a possibility to compare the two fields and to find
the
look-alike content of the field.

Is there same code available to do this?

Thanks for any help.

Kind regards,

Simon van Beek

Apr 28 '06 #3

This discussion was between sat 20 march and mon 22 march this year.

search google newsgroup for : help needed for implementing fuzzy logic
(7 messages in total)

Bas Hartkamp.

"HS Hartkamp" <ha**************@wanadoo.nl> schreef in bericht
news:44***********************@news.wanadoo.nl...

A couple of weeks ago in this group, there was a posting and a few replies
that did just this. It discussed some algorithms that compared similar
strings and the discussion was about the speed of the algorithm in
comparing large tables.

Unfortunately, I don't have time to look for this right now, but you can
try the archive of this group searching in google.

Bas Hartkamp.
"Simon" <S.******@HCCnet.nl> schreef in bericht
news:44**********************@dreader29.news.xs4al l.nl...
Dear reader,

For matching of two fields it is required that the fields has the same
content.

But now I have the situation that two text fields has not precisely the
same
content but there is some minute deference.

Now I am looking for a possibility to compare the two fields and to find
the
look-alike content of the field.

Is there same code available to do this?

Thanks for any help.

Kind regards,

Simon van Beek


Apr 28 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Stephen | last post: by
1 post views Thread by Prakash RudraRaju | last post: by
8 posts views Thread by Vincent | last post: by
4 posts views Thread by Dave | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by haryvincent176 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.