Iif Statement reading as text not expression - PLEASE HELP!

[zkoneffko]

I'm having an issue that I feel should be a simple fix but I simply can not figure it out.

I have an iif statement:

IIf([forms]![Main]![District] Is Null,IIf([forms]![Main]![DistrictList]="View all Districts",>0,[forms]![Main]![DistrictList]),[forms]![Main]![District])

The problem is the part that is >0 is looking at it as text and not an expression. Can someone PLEASE let me know of a way/function that makes the iif statement view that part as an expression.

 

[wazz]

your second IIf statement doesn't make sense.

IIf([forms]![Main]![DistrictList]="View all Districts",>0,[forms]![Main]![DistrictList])

>0 by itself doesn't mean anything. with quotes it might - ">0" - but i don't think that's what you're after.