How to create a dynamic query builder
Posted on 2009-04-14
I am trying to determine the best way to go about creating the code necessary to allow a user form to generate custom queries. I have thought of several approaches and none seem very efficient.
At least initially, the queries will all be based on the same table. So it is just a matter of defining what fields to include and what criteria for each field.
On the form, I am using radio buttons, check boxes and text boxes.