I am trying to find customers name that starts with "S" in my access database. If i run the following query in access its working fine.
Select Lastname from employees where Firstname Like '*S*';
it displays two records which is right.
if I use it in access it..its not working. Any idea why?
All other queries are working in VB. like if I use Firstname equals "Sam" but it doesn't work when I use Firstname Like '*S*'