Two ways for Query Results

  • Thread starter Thread starter Frank
  • Start date Start date
F

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
 
Got it from somewhere else. Thanks for looking.
Like Nz([Enter department] & '*','*')

Frank
 
Back
Top