You don't need single quotes around numbers in an sql query
set rsproj = conexao.execute("select * from projetos where id = " & rs("projeto") & "")
HTH
Faustine
--------
: everytime when I try to use "autonumber" field in SQL statements, it always give this error:
:
: Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression
:
: I'm trying this expression:
:
: set rsproj = conexao.execute("select * from projetos where id = '" & rs("projeto") & "'")
:
: ---
: id-> is an autonumber field of a table called "projetos"
: rs("projeto") -> is a number that is caught of another table called projs
:
:
: anything wrong ?
:
