Kevin R. Tishler wrote in message news:#j4NFOwIAHA.238@cppssbbsa02.microsoft.com...
> An address that is in a text field. How do you ignore the number in an
> address and find by the text in an address. Ex. 123 Main St. - ignore the
> 123 and find by Main St.?
> 
> Thanks,
> 
> Kevin
-----------------------------------------------------------------------------

Hmmm, you could parse that out in a query expression with the following code:

Function FilterNumberOutOfAddress(strProblemAddress As String) _
As String

'Remember your error handling

Dim strResults As String
Dim iCounter As Integer
Dim iStartHere As Integer

iStartHere = 1

    For iCounter = 1 To Len(strProblemAddress)
        If Not IsNumeric(Mid(strProblemAddress, iStartHere, 1)) Then _
            strResults = strResults & Mid(strProblemAddress, iStartHere, 1)
            
            iStartHere = iStartHere + 1
    Next
    
    FilterNumberOutOfAddress = Trim(strResults)
    
End Function

-- 
Calvin Smith
http://www.CalvinSmithSoftware.com
"Real-world Source Code Solutions"