Two ways for Query Results

[Frank]

Have a query that I would like to do two things. I have
put in criteria that states a specific department [Enter
Department]. What I want to do is if I desire to see all
departments, I could just hit leave the pop up box blank
and all would show up. If I wanted a specific department,
then I would enter it in. I hope this makes sense.

Thanks,

Frank

 

[Frank]

Got it from somewhere else. Thanks for looking.
Like Nz([Enter department] & '*','*')

Frank