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 Status]=[“Completed”] Or ([Task Status]=[“Rejected”]) Or ([Task Status]=[“Cancelled”]),IIf([Delta].[Actual End Date] Is Null,[Delta].[Last Update Date],[Delta].[Actual End Date])))
Any idea??? I am new to access and trying to work through this. Thanks,
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 Status]=[“Completed”] Or ([Task Status]=[“Rejected”]) Or ([Task Status]=[“Cancelled”]),IIf([Delta].[Actual End Date] Is Null,[Delta].[Last Update Date],[Delta].[Actual End Date])))
Any idea??? I am new to access and trying to work through this. Thanks,