Thanks for the quick reply! I modified the recordset to
SELECT DISTINCT products.* FROM products LEFT OUTER JOIN productcategoriesjoin ON JoinProduct = ProductID WHERE (ProductDeactivate = 0) AND (ProductExclusiveFire = 0 OR ProductExclusiveFire = 2) AND (ProductExclusiveFire <> 1) AND (ProductExclusiveBM <> 1) AND (ProductDeactivate <> 1)"
I uploaded to the live site and tested the live page, but the FireExclusive products still show. Do I need to modify the Data Assist Search parameters also?