Search Query

[Jeff Fredel via AccessMonster.com]

I am creating a query to look up ID numbers. I want the user to enter a
portion of text found in the field ProjectName and then return those
ProjectIDs that have the entered text. I cannot seem to get it to run
properly. In the criteria line I enter:

Like *[Enter Portion of Project Name]*

Any Assistance would be greatly appreciated.

 

[Rick B]

That criteria looks coorect.

What is it doing wrong?

 

[fredg]

I am creating a query to look up ID numbers. I want the user to enter a
portion of text found in the field ProjectName and then return those
ProjectIDs that have the entered text. I cannot seem to get it to run
properly. In the criteria line I enter:

Like *[Enter Portion of Project Name]*

Any Assistance would be greatly appreciated.

Like "*" & [Enter Portion of Project Name] & "*"

 

[Jeff Fredel via AccessMonster.com]

Thanks for the assistance. Worked great.