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
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: