Countiif Function with Multiple Criteria

[JithuAccess]

Hello Guys,

In my Report I want to show the Total count based on multiple criteria. I have put the following Function in the Control Source property of a Text Box:

=Count(IIf([strCountry]="USA",1) And ([strState]="CA",1) And ([StrCity]="Los Angeles",1))

But I am getting an Error

Could you please let me know how to fix this.

Thanks

 

[theDBguy]

I would use Sum() instead. For example:

=Sum(IIf([strCountry]="USA" AND [strState]="CA" AND [strCity]="Los Angeles",1,0))

Hope that helps...

 

[JithuAccess]

I would use Sum() instead. For example:

=Sum(IIf([strCountry]="USA" AND [strState]="CA" AND [strCity]="Los Angeles",1,0))

Hope that helps...

Thanks a lot. It works Perfect

 

[theDBguy]

Thanks a lot. It works Perfect

You're welcome. Glad we could assist. Good luck with your project.

 

[Pat Hartman]

I guess I wasted my time answering your other question:

Countiif Between Dates

Hello Guys, I want to get the total count based on two criterias. The first criteria is Country and the Second criteria is Date Received. The date received should be 7 Days prior to Today's Date. Today's date is 02-Mar-2021 and I want to find the total count between the dates between...

www.access-programmers.co.uk

Please don't post the same question twice.