Like keyword in Parameter Query

[meadows43]

I was wondering if it's possible to do pattern matching on the user's input for a parameter query? I've tried typing Like "*[Prompt goes here]*" in the criteria field in the QBE, but that doesn't work.

Any suggestions?

Thanks,
Chris

 

[dcx693]

Like "*" & [Prompt goes here] & "*"

 

[meadows43]

Like "*" & [Prompt goes here] & "*"

If this answer had teeth, it would have bit me. Thanks for the help, it works now.

Chris