Hi all,i have 2 dropdown list... 1 is month, another is year... which can let user to select which month or year they wanted to search for news. user can have 3 options to search for...1. select only month to search (1stdropdown)2. select only yar to search (2nd drop down)3. select both dropdown, means select month and year<%sql = "SELECT title, month, year, link FROM News"strWhere = " WHERE"if months <>"" thensql = sql & strWhere & " month LIKE '%" &months& "%'"strWhere = " OR"end ifif years<>"" thensql = sql & strWhere & " year LIKE '%" &years& "%'"strWhere = " OR"end ifif months<>"" and years<>"" thensql = sql & strWhere & " month LIKE '%" &months& "%' and year LIKE '%" &years& "%'"strWhere = " OR"end ifrs.Open sql, conn%>1 and 2 option can work.but the 3rd option, it did display results, but didn't merge the month and year.example i select month=january, year=2005suppose only display record for january 2005 ...but it display all record for january and 2005what i want is just only record for january and 2005any idea?thanks.