Multiple Update Queries

[MTSPEER]

Hello,



I have an update query where it takes data from one field and puts new data into another field. I only wanted those to show. For the rows that are blank in that field can I make another update query where it makes the blank rows show "Other"? I tried using an Iff statement and a Replace statement and it removed the previous update query as well and made those rows blank. Can anyone write the right syntax that would work for me? thanks

[orange]

Show us the code you are using, and some example of what you want.

[MTSPEER]

This is the code I used in the first update query: Switch([GroupName] Like "*SSD*","S",[Groupname] Like "*ATS*","D",[GroupName] Like "*CB*","D")..And I want to replace the empty cells in the field with "Other", so I tried making another update query, here's the one's I tried to use: Iff([PWO], " ", "Other"), and Replace([PWO], " ", "Other"). PWO is the field where the queries are updating to.