Parameter Query and wild card character

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
 
T

TPratt

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

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

Top