Parameter query that allows a value or blank for all results

[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

 

[Rick B]

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

 

[Jennifer Eckel-Naborowski via AccessMonster.com]

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