Search without using all search boxes

[me3]

Hi all,
My search form has, say, 5 search boxes. Eg.

Vee
Cathederal
RIB
Keel
Lifting Keel

I need to have all the boxes visible and searchable. BUT I only want to search one or two at a time. How do I do this?
Thanks

 

[pbaldy]

My tendency when there are more than one or two optional fields is building dynamic SQL, as demonstrated in the sample db here:

http://www.baldyweb.com/BuildSQL.htm