By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,105 Members | 2,560 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,105 IT Pros & Developers. It's quick & easy.

Compare two fields and to find the look-alike record

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a

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

P: n/a

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.