Long IIf Statement with Or statement inside

[BrianFawcett]

I have a long IIf statement that I am using in a text box to generate some totals at the bottom of a report. This is it below:

=Sum(IIf([Data Table]![Order Phase]="OE" And [CheckHardSale]=0 And [CheckCredit]=0 And [Afterclose Status]="Dormant",1,0))

I want to add in an Or statement inside -

OR [Conflict Phase] = "AAM","QA",Is Null

I cannot seem to get the paratheses and brackets right. Can someone straighten me out.

 

[GinaWhipp]

Try...

=Sum(IIf([[URL="http://www.access-programmers.co.uk/forums/showthread.php?t=212986#"][COLOR=darkgreen]Data[/COLOR][/URL] Table]![Order Phase]="OE" And [CheckHardSale]=0 And [CheckCredit]=0 And [Afterclose Status]="Dormant" OR [Conflict Phase] = "AAM" OR [Conflict Phase] = "QA" OR IsNull([Conflict Phase]),1 ,0))