Search Query

  • Thread starter Thread starter Jeff Fredel via AccessMonster.com
  • Start date Start date
J

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.
 
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.
Click to expand...

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