Query with SQL

[zoom14151]

I want to query a database table and use SQL and give the user the options to enter the fields to query. Can you display a form with text boxes and use the data entered in the text boxes in the SQL statement. I done think that is a problem, but can you have null values in the statement.

The answers to your questions are YES. I am working on an assignment doing just that right now. The text boxes can have entries that are used as criteria for the SQL query or they can be blank. My SQL statement is built dynamically depending upon the contents of the text boxes.