In minr project i use that query it is workinf fine.
“select * from attend where eid=” & CLng(eid.Text)
but i can not wirte a query for two fields. i try tyo write that
“select * from attend where eid= and field2=” & CLng(eid.Text) and clng(1)
but i get a error data missmatch.
can any body helpme??