I have a table called MasterCostCodeList. The two fields in the table are Level3 and Active. I have a query (not shown) that gives me orphaned records that I need to change (will only use five records for my example). So I have the following results:
I need to set the active field from 1 to 0. I have the following update statement:
My question is how do I add the remaining level3 records to the statement? I tried the following below but that does not seem to work. What am I missing that is probably so simple.
Where Level3='MO-1', 'MO-2', 'MO-3', 'MO-4', 'MO-5';