access database query

[rajjjjjjjjjjj]

query = "Select * from AssociateDetails where Project_Name ='" +
drop_proj_name.SelectedValue + "' and Competency_level='" +
drop_comp_level.SelectedValue +"' and Experience='" +
drop_exp.SelectedValue + "'";

I am performing this code in oledb connection with acess data base,
but i m not getting output for "AND" operator.same query using "OR"
gives the o/p.pls help me out to solve this problem how to use "AND"
operator in my query.Very urgent

thanks

 

[bcap]

Maybe there just aren't any records which meet ALL of the criteria?