Hi I am getting the an error stating syntax error in query expression ‘start date LIKE ‘2%”. The code concerned lookes like this:
Adodc1.RecordSource = “Select * From projandpro Where start date LIKE ‘” & Text5 & “%’;”
Can anyone help me modify this code so that I dont get this error. Another point of interest is that when I insert Letters into the text feild it works fine, however when a number is put the above mentioned error appears. Thanks
