Probably didn't make this very clear. Sometimes the search will include 2 of the options, others 3, 4, 5 or 6.
On 6/19/2013 10:51 AM, Dick Fey wrote:
One of my people wants a form with the ability to search a table based on 6 different product specs. One to six specs may be entered to be searched, others will have no values entered.Question;How to build a query statement that searches based on an unknown number of values.This can't be as hard as I am envisioning. Dick Fey Carpet Broker Inc.

