I have this code:<BR>sql = "SELECT * FROM TableName WHERE Variable = '" & var_id & "'"<BR>set query = db.execute(sql)<BR><BR>I have the connection opened elsewhere, in a header file, and all other queries are working fine. It's when I use the = '" & this_junk & "'" that I have problems. <BR><BR>I get this error at that 2nd line:<BR>Microsoft OLE DB Provider for ODBC Drivers error '80040e07' <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. <BR><BR><BR>Can someone help? What am I doing wrong? Thank!