Finding Partial Text in a Query

[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

 

[Marshall Barton]

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.

Change the criteria to

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