"WHERE" in SQL

[radek225]

in the following code "id_zlecenia" is text field and "idStarego" is string - This code wokrs well. BUT now
"id_zlecenia" is number filed and "id_starego" is long variable. How should look the new "WHERE"?

...

 "FROM TblDolZleceniaZakonczone " & _
          "WHERE [COLOR="Red"]ID_Zlecenia[/COLOR] ='" & [COLOR="red"]idStarego[/COLOR] & "' and Id_DolZlecenia=" & recIn!Id_DolZlecenia

 

[pr2-eugin]

Just remove the single quotes after the = and before the AND.