why the insert stmt doesn't work

[Kanan]

Hi,
My insert statement doesn't work with the where clause in Access 2003. it
works fine if I remove the where clause. Can somebody please explain the
problem. thanks
Kanan
cn.Execute "INSERT INTO temp_Data SELECT master_Data.* FROM Master_Data
WHERE master_Data.CourseTitle Like '*mutipli*patterns*';"

 

[RoyVidar]

Hi,
My insert statement doesn't work with the where clause in Access
2003. it works fine if I remove the where clause. Can somebody
please explain the problem. thanks
Kanan
cn.Execute "INSERT INTO temp_Data SELECT master_Data.* FROM
Master_Data WHERE master_Data.CourseTitle Like
'*mutipli*patterns*';"

If you're using ADO, the wildcard is % not *

 

[Steve]

It looks like 'mutipli" is misspelled.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]