access iif Wildcard in Query
Posted on 2011-03-06
Sorry this is so basic but...struggling.
I have a dropdown that I need to change and then the Query adjusts
Looks like this:
0 = All
1 = xxx
2 = yyyy
In the appropriate field in query design I have
I keep getting an error.
basically if they select all then bypass the criteria if not match the field.