I hope someone can help me with this question, please. I have a query page with 6 textfields, but how do I handle the empty fields when the user doesn't fill them all out? If I use the sql statement "and" to put all together then it will look for all 6 text fields. How do I do with these empty fields so they don't effect the whole query? Thank you very much!

If you use the LIKE variabele and the user fills nothing in the textbox, searching to this 'empty' textbox will automaticly be skipped.