I have a report that opens with data drawn through a query, really simple, straight from a table. In the query one of the fields is this formula:
MemberSymbol: IIf([MemberStatus]=1,'',IIf([MemberStatus]=2,"*",IIf([MemberStatus]=3," (ex)",0)))
Earlier today it was this:
MemberSymbol: IIf([MemberStatus]=1,Null,IIf([MemberStatus]=2,"*",IIf([MemberStatus]=3," (ex)",0)))
I was getting this message:
Invalid use of Null
So I changed it to the top formula, but I still get the same warning.
The query opens fine by itself and the WHERE statements generate correctly. It is only when I open the report that it throws the code. The macro that opens the report throws 'Error 2950'. I have the file location trusted. When I open the report straight from the list of reports on the left side it also throws the warning. So I know it's only when the report is opening.
I can't find any other Null argument anywhere in connection with the report.
Any thoughts on what to try?
I have attached the Front End in the zip.