Think you'll find the IIF statement below will work
Where there is "" at the end can be left or put an alternative in there. I did this as numbers, you can change to text or a mixture if you want. THis need to be placed in an updated query against Field2 to work.
Hope this helps