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

[Guest]

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.

 

[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.

As criteria on that search field, write:

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

No need for the user to enter the wildcard character.

 

[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.

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]