IIf help

[Boo]

I have a number type field in a query called Answer.
If the data in the field = 0, I want to show NA
I have this is the query:
Answer:IIf([Answer]=0,"NA")

I get an error message: Circular refrerence caused by alias Answer etc
I have searched this forum for examples, and mine seems to match the ones I have seen.
What am I do'in wrong?

 

[RuralGuy]

NewAnswer:IIF([Answer] = 0,"NA",[Answer])

 

[Pat Hartman]

You do realize that by substituting "NA" for 0, you are changing the field's data type from numeric to text I hope. This could come back to bite you if you later expect to do some calculations with this column. It is best to save this type of change for the report since it is really a formatting option.

 

[Boo]

Pat,
You are so very kind to offer extra info that I did not even know I needed.
I searched for how to format controls on a report, tried it, and it worked!!
Not too surprised it was your posting I used.
Many, many thanks to you, sweet person.
Erin

 

[Pat Hartman]

Having made just about every stupid mistake there is to be made, I recognize them when I see them which is either a blessing or a curse depending on how you look at it.