Parameter query that allows a value or blank for all results

  • Thread starter Thread starter Jennifer Eckel-Naborowski via AccessMonster.com
  • Start date Start date
J

Jennifer Eckel-Naborowski via AccessMonster.com

Hi -

I'm trying to create a parameter query that allows me to filter the query
by the employee last name or if I leave the parameter blank it will return
all employees records. I also have one other field that has criteria on it
and that criteria would need to be applied to either situation (all
employees or selecting an individual employee). Thanks

Jenn
 
Like [Enter Employee Name] & "*"


Placing the "other criteria on the same line will create an "AND" condition
meaning that it will always be applied in addition to the above. Placing it
on a separate line will create an "OR" condition.

Please get in the habit of searching for your answers before posting a new
thread. I have answered both of these questions many many many times in
these newsgroups.


Rick B
 
Thank you Rick. It worked great. Sorry for the new thread. I don't know why
I didn't do a search first. To busy rushing. My error. Thanks
 
Back
Top