NOT IN operator and mismatch

<i><b>Originally posted by : Armelle Aubry (armelle.aubry@sympatico.ca)</b></i><br />I receive an error '80040e07' ODBC Microsoft Access Driver<br />Data type mismatch in criteria expression.<br /><br />For this request<br /><br />SQLnon = "Select distinct idquoi FROM non WHERE idqui = " & Rsqui("id") & ""<br />strSQL = "SELECT * FROM Catalogue " & strSQL &" AND Id NOT IN (" & SQLnon &<br />")"<br /><br />which gives: :<br /><br />SELECT * FROM Catalogue WHERE prix = '10 000 - 15 000' AND Id NOT IN (Select<br />distinct idquoi from non WHERE idqui = '6')<br /><br />where does it come from ? Can access understand the NOT IN operator ?<br /><br />Thank you<br />