Finding Partial Text in a Query

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

Guest

To all,

Happy Holidays.

I have a query that I need to be able to find partial data in a text field.
The data in the field looks like this: SFC Doe, John M. There are numerous
entries in this field. I have typed in the criteria box of the query[ Enter
Last Name] so that the user can enter Doe in a pop up box, and get the
records containing the information for SFC Doe, John M.

Thanks for your help again.

SFCA
 
SFCA said:
I have a query that I need to be able to find partial data in a text field.
The data in the field looks like this: SFC Doe, John M. There are numerous
entries in this field. I have typed in the criteria box of the query[ Enter
Last Name] so that the user can enter Doe in a pop up box, and get the
records containing the information for SFC Doe, John M.
Click to expand...


Change the criteria to

LIKE "*" & [Enter partial name] & "*"
 
Back
Top