Help with a query 1

[choochoowinn2009]

How do I write in my query to search for multiple names starting with "COMMUNITY"?

Example: If I type "COMMUNITY", it will show me all 3 COMMUNITIES listings:
1) COMMUNITY ENLISTMENT
2) COMMUNITY ORGANIZATION
3) COMMUNITY ENFORCEMENT

If I use the "LIKE" command, and enter "COMMUNITY" only, it comes up with NOTHING. That's not how I'd like to see my results.

Please help! Thank You!!!

 

[dhookom]

You criteria would need to use the "*" wildcard character.

Assuming you have a form with a control Forms!frmSearch!txtSearch, the criteria might look like:

  Like Forms!frmSearch!txtSearch & "*"

Duane
Hook'D on Access
MS Access MVP

 

[choochoowinn2009]

Thank you so much. It works!

I put that in the criteria search in my query as a pop up window for the user.

Thank you!!!!

 

[dhookom]

IMO, never make your users face pop up windows. Take a look at faq701-6763.

Duane
Hook'D on Access
MS Access MVP