Criteria Problem in Query

[robbro]

Im trying to specify a criteria that allows me to input either "A", "B", "C" or "All". ("All" meaning A, B, and C)

If I use [Enter A, B, or C], I can run the query specific to each individual location, but I havent been able to come up with a statement that will allow me to use "All". The best I can do so far is to set up two querie, a "Location Specific" query, and one that is not.

Any Help? I tried:
IIf([Enter Location: A, B, C, or All]="All",>="A",[Enter Location: A, B, C, or All])

But I think I'm wayy offf. Just too green..

 

[Trendsetter]

Most programms that I develop I get all records by leaving the parameter empty or blank.
If you want to do it this way, in the criteria enter:
Like[Enter A, B, C or leave blank for ALL] & *

Let me know how you get on !

 

[robbro]

Thanks a bunch. That worked excellently. Now my only problem is when the location field is left blank. I would like these to display in the "all" case, but they are ignored.

I've taken a big step though, Thanks.