Multiple Count's in 1 expression?

[markjohnson]

Hi,

I have a report that I have called "0 Master". It details the number of complaints that my company has received, broken down by a specific service.

I have a CountIIf that returns the number of complaints received in a certain category. This works - but this only shows the total number of complaints received for that specific category.

That formula is
=Count(IIf([Contact Category]="Stage 1 Corporate Complaint",1))

I have also got a formula that tells me the total number of those complaints that are outside of the deadline (regardless of category).

This formula works and is;
=Count(IIf([Date Response Expected]>=Date(),1))

But - I want to combine these 2 formulas to tell me the number of complaints outside the deadline for a particular category - I've had a go myself and anything I do tends to return either nothing or -1

So far, I've tried various incarnations of;
=Count(IIf([Contact Category]="Stage 1 Corporate Complaint",1)) And (IIf([Date Response Expected]>=Date(),1))

Please help?

 

[namliam]

=Count(IIf([Contact Category]="Stage 1 Corporate Complaint" And [Date Response Expected]>=Date(),1))

something like that??

Ow those column names

 

[markjohnson]

Thats it - cheers