Give them a form that gives them all the options to ask their question. Kind of like a customer search. Someone may way want to search on the customer name, another on the city, etc. Just make them choose on what column to search.
-----Original Message----- From: Dick Fey <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 19 Jun 2013 10:51:49 -0500 Subject: [RBASE-L] - How To... Suggestions ? > 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. > >
