Access - Lookup and query

Associate
Joined
1 Sep 2005
Posts
724
Hi

I have an access query as it is certainly not my strong point.

I am looking at a query that i would like to run, i have it working but could it be done better.

In a table i have a datatype field of lookup that is picking up the following from another table eg:

1:ONE
2:TWO
3:THREE

I want to be able to search all based on selection option 3 as 3 is the default ie the search for 1 and 2 so 'All'

I have it working if i do a usual OR statement ie

1 OR 2 as a variable set based on the user selecting an option in the form.

Any cleaner way to do this besides an OR statement?

thanks
 
Last edited:
Back
Top Bottom