[resolved]DataType Mismatch

hi i m doing a project in which i connect a MS Access DataBase...

i have a field Q_id which is number. but when i open the table using

VB Code:

rs.Open "select * from questions where q_id='" & CInt(LQNumber(Q - 1)) & "'", db, adOpenDynamic, adLockOptimistic, adCmdText"

but it says "datatype mismatch in criteria expression"

pls help me

thanks

Remove the surrounding single quotes....

VB Code:

rs.Open "select * from questions where q_id=" & CInt(LQNumber(Q - 1)) & "", db, adOpenDynamic, adLockOptimistic, adCmdText