wildcard

J

Joel Allen

Hello,

I have the following criteria in a query. It will find anything with the
letter "H" in it and it works.

Like "*H*"

I want it to be a a prompt though when you run the query so that the user
would enter "H". I've tried everything and can't get it to work. Any help
is apprieciated.

Thanks,
Joel
 
M

Marshall Barton

Joel said:
Hello,

I have the following criteria in a query. It will find anything with the
letter "H" in it and it works.

Like "*H*"

I want it to be a a prompt though when you run the query so that the user
would enter "H". I've tried everything and can't get it to work. Any help
is apprieciated.
Click to expand...


Like "*" & {Enter letter] & "*"
 
J

Joel Allen

Thanks!

Marshall Barton said:
Joel said:
Hello,

I have the following criteria in a query. It will find anything with the
letter "H" in it and it works.

Like "*H*"

I want it to be a a prompt though when you run the query so that the user
would enter "H". I've tried everything and can't get it to work. Any
help
is apprieciated.
Click to expand...


Like "*" & {Enter letter] & "*"
Click to expand...
 
J

Joel Allen

Thanks!

Jerry Whittle said:
Put this in the criteria:

Like [Enter the first letter] & "*"
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Joel Allen said:
Hello,

I have the following criteria in a query. It will find anything with the
letter "H" in it and it works.

Like "*H*"

I want it to be a a prompt though when you run the query so that the user
would enter "H". I've tried everything and can't get it to work. Any
help
is apprieciated.

Thanks,
Joel
Click to expand...
Click to expand...
 
Top