I can send you a form that works the way you want, I think. It's from my
soap box application. If you want it, I'll email you the whole app and
you can play with it.
Albert
On 19/06/2013 9: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.
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.3345 / Virus Database: 3199/6422 - Release Date: 06/18/13