i connected access database with vb
now from a combo box i am taking the string in a variable wk
now i want to open the access table with sql query on the basis of wk
i want to know the syntex
i am not able to complete the systex
i.e.
select * from aa where aa!weekt=wk
this is not working
what to do