I'm trying to create a search page using ASP and MS Access. Most of the fields contain these values= YEs, No, Maybe If the user ticks the...

I'm trying to create a search page using ASP and MS Access. Most of the fields contain these values= YEs, No, Maybe If the user ticks the checkbox, there is no problem, he wil get all the entries with "Yes" so in the sql statemnt : Select * FROM Main WHERE Option = 'Yes'. No problem with that... However, If the user does not tick the check box, i do get a recordset containing ANY value of Option. So the best thing is to not make any mentioning in the sql statement..Right? Well...At this case i could use an If statement. But I have around 20 check boxes...What should I do? Please Help!!! Thanx Nick