Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do i make it so that a query looks for words like what the user in
- Thread starter KaayJaay
- Start date
In the criteria of the field use
This will bring up a dialog asking for the name and will return all of the matches. This is looking for the string anywhere in the name, not just at the beginning.
Alan
Senility at its finest
Code:
Like "*" & [Enter name to search] & "*"Alan
Senility at its finest
- Status
Similar threads
- Question
- Question