Help,

I have a form that geathers information from my customer, the querys the database.
The first field thisform.text1.value is a date field (Paiddate), the next field thisform.text2.value (text(group code)), the
next field thisform.text3.value(text(group code)).
What I'd like to do is enter a date in the first field, and enter different group codes in the other fields, and if any of
the other fields empty, ignore them.
EXAMPLE:
search for paiddate = thisform.text1.value and group code = thisform.text2.value ;
or group code = thisform.text3.value or group code = thisform.text4.value.

Is there a way to search only the text box's that have info in them ? And if so,
can anyone give me an example ?

Thanks