[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria express

[EMP]

I keep getting this error [Microsoft][ODBC Microsoft
Access Driver] Data type mismatch in criteria expression
when I try to create a second recordset from the same
table within the first recordset. What am I doing wrong?

 

[Dirk Goldgar]

I keep getting this error [Microsoft][ODBC Microsoft
Access Driver] Data type mismatch in criteria expression
when I try to create a second recordset from the same
table within the first recordset. What am I doing wrong?

You'd have to post your code.