Quite a lot to ask really, don't you think?
To start with, you need a html form that looks like this
<input type="checkbox" name="searchchoice" value="holidays" />
<input type="checkbox" name="searchchoice" value="cars" />
<input type="checkbox" name="searchchoice" value="monkeys" />
and an asp page that does something like.....
dim c, r, s
set c = createobject("adodb.connection")
set r = createobject("adodb.recordset")
c.connectionstring = (connectionstring needed here)
c.provider = "Microsoft.Jet.OleDB.4.0"
s = "select * from wherever where something like '" & request.form("searchchoice") & "'"
Set r = c.execute(s)
while r.eof = false
response.write r.fields(0) & "<br>"
response.write r.fields(1) & "<br>"
response.write r.fields(2) & "<br>"
you'd need something in place that makes sure they only select one choice, otherwise it will screw the SQL statement up.......
If you selected "Holidays" then the SQL would be select * from wherever where something like 'holidays' and if the other choices are picked, holidays would be replaced with the respective choice. then a simple loop will write out all rows that match the SQL statement.
I'd recommend a book on ASP!
By the way, that won't work by itself but it demonstrates what you need to do, in a crude way.