Two accomplishments with one query

[cornishteeth]

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

 

[Norie]

Try this crteria instead of just [Enter Department]

Like (IIf(IsNull([Enter department]),"*",[Enter transaction] & '*'))

or

Like Nz([Enter department] & '*','*')

 

[cornishteeth]

Like Nz([Enter department] & '*','*') worked perfect. Thanks for the quick response.

Frank