I am new to Access and I am stuck.
I want to iterate through an entire table deleting all rows in which a Column text contains the substring "LLC".
I have been trying to use INSTR() but I can not figure out how to make it work with something like:
strSQL = "Delete * From [TABLENAME] WHERE [COLUMNNAME] ...contains the substring...
DoCmd.RunSQL strSQL
Thank you for your kind assistance.