Select Query

[mdmatiullah]

Hi,
I have dept no separated with comma in a string str1 and a table of deptno Table named as 'dept' and field as deptno .I want to search the string str1 in table dept and get the deptno that does n't exist in table dept .

Thanks
Md.Matiullah

 

[vbaInet]

Aircode:

str1 = Replace(str1, ",", ",'")

strSQL = "SELECT * " & _
         "FROM dept " & _
         "WHERE deptno IN ('" & str1 & "');"

strSQL will now contain the SQL statement you can use in your form or report.