Query by Form Text Boxes, can it be done..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 15 columns of data I'd like to filter. The database I'm creating is
supposed to be so user friendly someone with no experience can navigate.

Anyhow, the idea is to have a form set up with 15 text boxes the user can
input values into, each box corresponds to a column to be searched.

Is there a way to set up a query to allow for any number of the 15 text
boxes to remain empty and still query the results filtering by the user
defined values?
 
In the code behind the form, parse each of the entered values into a SQL
WHERE clause.
 
Back
Top