IIF results in #Type! in Access
Posted on 2014-02-24
I have an Access report that I want to grab 3 description fields and combine them using IIF so that if a field is null, it doesn't display anything. I'm trying to use:
=IIf(IsNull([FIELD1]),"","FIELD1 DESC: " & [FIELD1]) & IIf(IsNull([FIELD2]),"","FIELD2 DESC: " & [FIELD2]) & IIf(IsNull([FIELD3]),"","FIELD3: " & [FIELD3])
But I get #Type! errors when I try to display the report.
I'm new to IIF but as I understand it, what I've done SHOULD work... shouldn't it? Your assistance is appreciated.
I don't think it makes a difference, but to be clear, the data lives in a SQL database and Access is only the front end.