not like in where clause (1 Viewer)

[mikeo1313]

I've used like clauses before without a problem in other sql statements,,, wondering why these prompt me to enter a parameter for filterm.prod details


DoCmd.RunSQL " delete from filterM where filterm.[product details] not like '*scrap*' "

DoCmd.RunSQL " delete from filterM where [filterm].[product details] not like ""*scrap*"" "

 

[mikeo1313]

also tried it like this

DoCmd.RunSQL " delete from filterM where [product details] not like '*scrap*' "

 

[mikeo1313]

the statements work, issue was the table was missing the column