Wildcard Search

[Erod1980]

I have a form for which I want to use the value entered in a field and do a
wildcard search from it. so if they enter 6878941891, and value in the table
has $687894189$, I want that record brought in. How do I do a wildcard
search in a query using the value input in the field
[Forms]![fProviderTINSearch]![ProviderTIN]?

Thanks,
Erod

 

[Ron2006]

Make the criteria for the search similar to the following:


like "*" & [Forms]![fProviderTINSearch]![ProviderTIN] & "*"


Ron

 

[Larry Linson]

I have a form for which I want to use the value
entered in a field and do a wildcard search from it.
so if they enter 6878941891, and value in the table
has $687894189$, I want that record brought in.
How do I do a wildcard search in a query using
the value input in the field
[Forms]![fProviderTINSearch]![ProviderTIN]?

You will have to define what you want in a bit more detail.

A table value of "$687894189$" would be a text string, not a numeric value.
Is this correct?

Your search entry example includes one additional numeric character more
than the numeric characters embedded in the string. How many, if any,
characters at each end of the search-for value do you want to ignore? What
do you want to do if the length of the search entry is less than the total
number of values to be ignored?

Larry Linson
Microsoft Office Access MVP