IIF statement with an AND and an OR

[gheyman]

Is this correct?
MONTH1_PDL: IIf(((DateDiff("m",[PDIR Due Date],Now()))>1) And ((DateDiff("m",[PDIR Completed],Now()))=<1) Or ([PDIR Completed] Is Null),1,0)


I need the first condition met and only one of the next two to true

[PDIR Due Date],Now()))>1 Needs to be True

AND
[PDIR Completed],Now()))=<1 OR ([PDIR Completed] Is Null Needs to be True

Should the last two be enclosed in a bracket?

 

[Joe4]

Re: Access: IIF statement with an AND and an OR

Not quite. Try this:

MONTH1_PDL: IIf((DateDiff("m",[PDIR Due Date],Now())>1) And ((DateDiff("m",[PDIR Completed],Now())=<1) Or ([PDIR Completed] Is Null)),1,0)

The trick is to write each condition separately, and comletely, and then just drop into the structure you need, i.e.
IIF((condition1) And ((Condition2) Or (Condition3)),1,0)