User created search criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Not sure if this is the right newsgroup to post this. If not, please let me
know and I'll repost it to the correct one.

I'm trying to figure out how to create a query where the user enters the
criteria (that part is no problem.) I want the query to search not only on
the letters the user types in, but other variations of that word. (I think
there is a name for that, but I don't know what it is).

For example, if the user types in "ABC" in the search box, I want the
results to display "ABC" as well as "A.B.C." and/or "A B C".

Any ideas?
Thanks in advance.
 
Hi,


The easiest way would be to enter


LIKE "*A*B*C*"

as criteria. If the argument to the right is to be a parameter, then to
instruct the end user to use * between each letter:


LIKE "*" & [enter each individual pattern separated with a * ] & "*"



So, if someone enter A*BC*D then the criteria would keep "A-BC. D" but
not "A-B/C#D" since BC constitute a "pattern" to be "as is".



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top