Parameter Query with Parameter value(s) or no entry returns all

[Guest]

Hello:
I used to know how this was done. I want to set up a parameter in the query
such that upon enter, the result set returns either a) based on value(s)
input in the parameter dialogue; or b) user enters nothing and resultset
returns all.

Your help is always invaluable.

 

[Lynn Trapp]

Put something like this in the criteria section for the field you need to
have the parameter in.

LIKE "*" & [Enter Value] & "*"

 

[Guest]

Thanks. I have exactly that. Now I would like to expand on it and be able to:
add multiple values

so:
add [a single value] or [multiple values] or [nothing and return all]

Your expertise is very helpful~

Put something like this in the criteria section for the field you need to
have the parameter in.

LIKE "*" & [Enter Value] & "*"

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Hello:
I used to know how this was done. I want to set up a parameter in the query
such that upon enter, the result set returns either a) based on value(s)
input in the parameter dialogue; or b) user enters nothing and resultset
returns all.

Your help is always invaluable.

 

[jonwaynew]

Thank you so much for this easy and clear to understand solution to this problem. I was ready to pull hairs.