IIF OR Statement Issue

[proevn]

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,

 

[Joe4]

Welcome to the Board!

You only put square brackets off of table and field names. Remove them from the values you are checking. Also, Access is particular and does not like slanted double-quotes, it wants straight ones.
So change all things structured like this:

[COLOR=#333333]=[“Completed”] [/COLOR]

to this:

="Completed"

 

[proevn]

Welcome to the Board!

You only put square brackets off of table and field names. Remove them from the values you are checking. Also, Access is particular and does not like slanted double-quotes, it wants straight ones.
So change all things structured like this:

[COLOR=#333333]=[“Completed”] [/COLOR]

to this:

="Completed"

So that is what I have been entering, but when I click off the query field, Access was automatically putting the bracket around the values I was checking.

However, it looks like maybe the slanted double quotes fixed this issue.

 

[stumac]

It seems like an overly complicated way of calculating what you are calculating... does something like the following work:

Closed Date: IIf([Delta].[Closed]="Y" Or [Task Status] In ("Completed","Rejected","Cancelled"),Nz([Delta].[Actual End Date],[Delta].[Last Update Date]))