Solved List Query Results From Partial Entry

[vcarrill]

Hello!

I have a table with fields that include supervisor and department.

I have a query with [Enter Supervisor Name]
Currently, I have to enter the Full Name in order to see the result, same issue with Department.

Appreciate the advice, thanks you.

 

[theDBguy]

Hi. In the criteria for the supervisor's name, try using something like this:

Like "*" & [Enter Supervisor Name] & "*"

Hope that helps...

 

[vcarrill]

Sir, you are seriously a legend! Thank you!!!

 

[theDBguy]

Sir, you are seriously a legend! Thank you!!!

Hi. You're welcome. Glad to hear you got it to work. Good luck with your project.