How can a User use wildard * in a "parameter required" form/Query

C

Carol Black

Using Access 2003. I have Created a Query with a parameter for one of the
fields. I would like the users to be able to use wildcards in the parameter
pop-up box.
 
F

fredg

Using Access 2003. I have Created a Query with a parameter for one of the
fields. I would like the users to be able to use wildcards in the parameter
pop-up box.
Click to expand...

As criteria on that search field, write:

Like "*" & [Search for?] & "*"

No need for the user to enter the wildcard character.
 
J

John W. Vinson

On Thu, 3 May 2007 14:33:00 -0700, Carol Black <Carol
Using Access 2003. I have Created a Query with a parameter for one of the
fields. I would like the users to be able to use wildcards in the parameter
pop-up box.
Click to expand...

Use a criterion of

LIKE [Enter parameter:]

instead of just the parameter.

To automatically include wildards, you can use

LIKE [Enter parameter:] & "*"

for example.

John W. Vinson [MVP]
 
Top