Everyone forget about Pound Puppies?? For your columns in your Select clause:
Cho vCho from #Columns in TableName For your Where clause Cho vCho from #Where in TableName ----- Original Message ----- From: "Dick Fey" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, June 19, 2013 11:51 AM 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. : :
