searching for names and parts of name using queries

  • Thread starter Thread starter Helen55
  • Start date Start date
H

Helen55

I am trying to set up a query where the user is prompted for the Name -
however I not only want the name to appear I also want to be able to retrieve
results that contain part of the word in the search as well
 
if you are doing it via a prompt then set your criteria to
Like "*" & [Enter Full or Part of Name] & "*"

If you are doing it via a textbox on a form then enter your criteria as
Like "*" & Forms![FormName]![TextBoxName] & "*"
 
Back
Top