I have a form that I am building a text box to display what the current status is based on the users inputs to assist with their selection of what they intend to report. Using a series of IIf statements to determine how their selections will be reported. I have all of them working except 1.
=IIf(([Total# of 111 Days] Is Null Or [Total# of 111 Days]<>[Unit Reported # Days to be Used]) And [ATStatus]="Conducting Less Than 15 Days of AT (Remarks Required with total #days to be utilized)","< 15 Day Order Unit Reported","Error")
The Highlighted part of the expression is what I have determined is the fault. Both are Number fields and what it should be doing is determining if one field is NOT EQUAL TO the other (i.e. 4 does not equal 3). Can anyone tell me what I am doing wrong?