Compare two Fields

[turtle]

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

[fredg]

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