Counting field values in a Database Report using the Count and IIF expressions

[Jmundle]

I would like to use the Count if Expression for more than one value. =Count(IIf([Status]="Active",0))th is works for 1 value
I also need to add another field

Example: Count if Status = A or B or C and count if Deploy Date is greater than today.

Thank You in advance. :)

[ADezii]

DCount("*","Table1","[Status]='A' Or [Status]='B' Or [Status]='C'")

[Jmundle]

ADezii,
Thank You for you Help and how do I add the second part
which is a different field?