Setting a Queries Criteria based on specific value inputs

[r3df1sh]

I have a query that has a criteria set based on a particular field in a report. That field is generated from a list of locations along with an all option.
Is there a way I can set the "ALL" entry to show all records while keeping the individual Location# intact?

Thanks for any enlightenment.

 

[ggreg]

r3df1sh,

I am sure someone will come in with a better way than me but
I would have a second query made that gets all the locations and I would have a button that would say all locations, now if they did not want all
locations there would be a second button that would let them pick the location they wanted this would be an easy way to do it... but my guess is you could do it also by doing some kind of IF statement that IF ALL then = (like the wildcard *)* else enter location needed

 

[Mile-O]

(How to add (All) to a combobox or listbox)