Query Expresssion Not Working

Good day,



I have written the expression below in my query and for some reason it isn't working, can anyone help please.

Code:

---



ThirdLineAdd: IIf([strThirdLineAdd]="","x",[strThirdLineAdd])

---

What I am trying to do is if the third line address field has nothing in it, I then want to populate it with a lower case "x"



If it does have something in it, then keep that value.



Any assistance would be most appreciated.



Regards



John Lee

Query Expresssion Not Working