I have a text field that has NULL values and I am trying to make the query return N/A when the value is NULL. Here is the expression I am using in the query:
AttName: Nz([NameField],"N/A")
It is not returning N/A. All I see is a blank and I am trying to compare it to another field where the value is N/A and the query is failing. What could be causing this? I also tried IIf(IsNull([NameField],"N/A",[NameField]) and that fails too which leads me to believe that it is something with the field type itself.