>thanks Boris, but i want to use from my form. If user check first, where sex=thisform.option.value=1( record should be filter sex=1)
>check ii =where sex=thisform.option.value=2 ( record should be filter sex=2)
>check iii where sex=thisform.option.value=3 ( record should be filter sex=1 and sex=2)
lnSex = thisform.option.value
SELECT ... FROM ... WHERE (Sex = lnSex OR lnSex = 3)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.