I've written the following SQL statement:
WHERE (Student_ID LIKE '1*')
It works in a query in MS-Access, but when I use THE SAME statment in VB (I use Data-Environment) it doesn't work. Why??
I have tried to use "[Student_ID]" instead of "Student_ID", "*" instead of "Students.*" etc... Nothing helped.
P.S. I will increase points if I get an answer shortly!!!