Wildcard Search

  • Thread starter Thread starter Erod1980
  • Start date Start date
E

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
 
Make the criteria for the search similar to the following:


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


Ron
 
Erod1980 said:
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]?
Click to expand...

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
 
Back
Top