Can anyone tell me.why this sql statement is not working.Any help would be highly appreciated.
here is the following statement.
Code:
 strsql = " SELECT *" & _
  " From ALRAJHIBANK " & _
 " WHERE (((ALRAJHIBANK.ID)= & itemID & ))"
Meanwhile this is working properly.
Code:
strsql = " SELECT *" & _
  " From ALRAJHIBANK " & _
 " WHERE (((ALRAJHIBANK.ID)=3))"