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

Compare two Fields

P: n/a
I have two tables that both contain a part number field. I have been
asked to find a way to show if the two fields match (easy enough) but
also need to find those that closely match. I have been told that if
the first 9 characters match that it would be a sufficient enough
match. I think using the Lens function would work but I am unsure.
any help is appreciated.

KO

May 2 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 2 May 2006 10:22:22 -0700, turtle wrote:
I have two tables that both contain a part number field. I have been
asked to find a way to show if the two fields match (easy enough) but
also need to find those that closely match. I have been told that if
the first 9 characters match that it would be a sufficient enough
match. I think using the Lens function would work but I am unsure.
any help is appreciated.

KO


If Left([FieldName1],9) = Left([FieldName2],9) Then
' It's a close enough match
Else
' It's not close enough
End If
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
May 2 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.