Hi All....
I'm building a search page consisting of several dropdown menus.
Each dropdown is populated by a recordset.

If a visitor only makes a selection from a couple of the dropdown menus, how
would i create the results page?
For instance:
There are 5 dropdown menus. Name, Address, Postcode, Telephone, Email
Visitor A selects options from the Name, Postcode and Telephone dropdowns
but doesn't select anything from the other two.

How would i write the SQL Query for this?

Thanks in advance

Andy