wildcard

[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

 

[Guest]

Put this in the criteria:

Like [Enter the first letter] & "*"

 

[Marshall Barton]

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.

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

 

[Joel Allen]

Thanks!

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.

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

 

[Joel Allen]

Thanks!

Put this in the criteria:

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

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