Your last UPDATE statement should work. Access is often a bit crap though so although it should work, it probably won't. Thanks Microsoft Access dev team (probably more specifically the updates to JET)...
Open the query designer for a new query.
Add the tables you are interested in.
Drag the field number from table1 to table2
Drag the field code from table1 to table2
Right click on each of the lines ...
Well, I figured it out. I didn't realize that when I use OR, the macro parses it like WHERE (X LIKE Y) OR (X Like Z).
The solution is as follows:
ApplyFilter WHERE Table!Articles!IntCodes LIKE "...