Make an Advanced Search page with optional input fields

How to make an advanced search page with 2 or more input parameters?

I want to make one advanced search page for my application. I have some 7 input fields(parameters) in the search form. I have to make all these 7 parameters optional (even if some fields are left empty the results for the selected/entered fields should be displayed. i.e., if I have entered only 4 input fields and left the other 3 empty, the results for the entered 4 inputs shall appear.)

Advanced Recorset Modification

I am trying to make an advanced recordset. I need some to help for that.

Need:

I am making a search page & results page with multiple parameters. For that I  have to use Advaced recordset options. I have got some ten input fileds in the search form. in the result page I have setup the Advanced recordset writing Sql Query using AND to make the results very particular. It works fine. THE PROBLEM IS, unless, I enter all the parameters the recordset returns empty. I want to make some fields optional by adding a check box in the search page.. sothat I can get the results even without entering all the ten parameters.

Can anyone tell me how to modify the Sql query & other possible solutions