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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Put something like this in the criteria section for the field you need to
have the parameter in.

LIKE "*" & [Enter Value] & "*"
 
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~
Lynn Trapp said:
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


Bettergains said:
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.
Click to expand...
Click to expand...
 
Thank you so much for this easy and clear to understand solution to this problem. I was ready to pull hairs.
 
Back
Top