Unanswered: Use "IF" statement to find single instance of text
I'm fairly new to this - and learning every day. My dilemma is that I want to use something (macro?) to create an "IF" statement that reads a field in a table, and if a specific instance of text is found in any record, then continue with the IF/THEN condition.
From a business standpoint, I want to use an IF condition to see if TABLE A has the value "Elk Lighting" in any of the records in the field "Brand". If the condition is true, continue on with running other queries (to clear tables, etc). I'm concerned that my IF statement was to run now, every instance of "Elk Lighting" would kick off the "clear this table" query.
I can't find a way to do this, and could really use your help. Thanks in advance.