Parameter Query and wild card character

  • Thread starter Thread starter SMatthew
  • Start date Start date
S

SMatthew

Can wild card characters be used in parameter query. If
yes How? If no is there any other option. What I am
trying to achieve when I run a parameter query it will
prompt me for a name for example if I type Jack* it has to
give me the results Jackie, Jack jr....

What do I do to accomplish this.
Smitha
 
In the criteria section of your query you type something to the effect of

Like [Enter a Name] & "*"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I search for an * in a text field? 1
Wild Card Doesn't Work ANymore 3
Wild characters in parameter query 1
What is the wild card for an Access query (MS query) parameter? 2
Parameter query to get info on an individual customer or all custo 1
Parameter Query Lookup 2
Wild Card in a Querie 2
Update Query with Parameter 3

Back
Top