Hi, I need help regarding the query to pull items from the item list. I would like to pull two types of items: items with Product Label Value 1 and Product Label Value 2 to queue 1, and items with Product Label Value 3 to queue 3.
I'm using the query "WHERE Product = 1 AND 2," but it doesn't seem to work. However, when I use "WHERE Product <= 2," it works. But in a future model that I will build, I may need to pull item labels like 2, 5, 7 and 9. So, I'm not sure if "WHERE Product <= " is the correct way to pull multiple label values.
Thank you for helping me out!
