Like query with parameter?

[sami0202]

Is there a way to do a like query where it will ask the user to input the data. I have a field with different committees listed in it and I need to pull out certain committies. But I need to keep in mind that one person could be on multiple committees.

Thank you for your help.
Sharon

 

[dhookom]

I'm not sure how "like" would resolve multiple committees querying unless the committee names contained similar text. In addition, IMHO parameter prompts are not acceptable user interface faq701-6763.

Wait, you don't have multiple values in a single field do you :-( If you do, you might want to change your table structure to a more normalized one.

Duane
Hook'D on Access
MS Access MVP

 

[randy700]

Something like this?

SELECT * FROM myTable WHERE CustomerNbr LIKE [Enter Value] & "*"

Randy

 

[sami0202]

Duane, If I had created this database from scratch I would have done it differently, however I'm stuck with what I have. Thank you for your suggestions.

Randy, After a few false starts I finally got it working, Thank you.

Thanks to TekTips, without you guys/gals I'd be in a heap of trouble.

Sharon