picklist drop down..

probably a stupid question but how do I script for multiple criteria when I use a drop down picklist in my form. i would like to search for products that quantity > 0 and are "active". I have tried the following and variations of it...

values = Products[Quantity > 0 & Radio_1 = "Active"].Product_Name

(I used a + sign etc.)

Thanks in advance.