I have this long IIF statement. Access appears to be placing [] around my quoted TRUE statement in the OR part of the statement.
Here is the query:
Closed Date: IIf([Delta].[Closed]="Y",IIf([Delta].[Actual End Date] Is Null,[Delta].[Last Update Date],[Delta].[Actual End Date]),IIf([Task...